I have to restore a DB to a new server and I have 16 files names 1-16
When I try the restore I select all of the files and press go but the message comes up:
SQL SERVER – FIX: Msg 3132, Level 16
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server 'WIN-SQL'. (Microsoft.SqlServer.SmoExtended)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The media set has 16 media families but only 1 are provided. All members must be provided.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3132)
What is wrong - do I need to specify the order of the files in teh restore?
image.png You have insufficient rights to see the content.
Buy new and refurbished computer equipment