A backup I am trying to restore has 1 mdf file and 85 ndf files.
The server I am trying to restore doesn't have enough space in the default location.
I can use the following to change the path. Do I have to use 85 move lines to create the script or is there way I can specify one place for all ndf files?
Thanks for your help!
restore database DB
WITH MOVE 'BBACK_Data' TO 'D:\MSSQL\DATA\BBACK.mdf',
MOVE 'BBACK_Log' TO 'D:\MSSQL\DATA\BBACK_1.ldf',
replace, recovery, stats=5, maxtransfersize=1048576