I have a question regarding proper syntax for restoring a 2016 SQL Server database.
One database 1 mdf no issue. But I need to restore a database that has 3 mdf files and 73 ndf files and then apply 2 differential back ups.
RESTORE DATABASE [Database] FROM DISK = N'E:DataServer_Database_20210213221000_full_1_of_2.bak', DISK = N'E:DataServer_Database_20210213221000_full_2_of_3.bak' DISK = N'E:DataServer_Database_20210213221000_full_3_of_3.bak' WITH FILE = 1, REPLACE, MOVE 'Database' TO 'E:DataDatabase.mdf', MOVE 'FactPart00' TO 'E:Data1FactPartFactDatePart00.ndf', MOVE 'FactPart01' TO 'E:Data1FactPartFactDatePart01.ndf', MOVE 'FactPart02' TO 'E:Data1FactPartFactDatePart02.ndf', ... all the way to 73
The above part works my question is now once how do I then restore diff file
To restore the diff will I also need to reference all the ndf files as well or just restore. What should my syntax look like? I don’t have an error since I have not ran it as I am nervous about corrupting database.