>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?