>Here is a script:
>
>

>
>RESTORE DATABASE [DbTest] FROM  DISK = N'C:\SQL DB Backups\AW.bak' WITH  FILE = 1,  
>MOVE N'AdventureWorks_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DBTest.mdf',  
>MOVE N'AdventureWorks_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DBTest.ldf',  
>NOUNLOAD,  REPLACE,  STATS = 10
>

>
>If you do this in SSMS, type the new name in the restore to dialog (in the options). This is generated as MOVE option in RESTORE command.
>
>See attached screen - you need to type the new name where I show - type here.

Thanks, I have a bunch of .ndf which I do not need to restore. Is there a way to adjust this script to only restore the mdf and the log?