Reset Password · PC & Mac Help and Assistance

Welcome Guest! To enable all features please Login or Register

Posted by: DogMan - 21 September 2022 20:31:47
Hello 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) For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47021.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: 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) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-3132-database-engine-error ------------------------------ BUTTONS: OK ------------------------------ What is wrong - do I need to specify the order of the files in teh restore?

Posted by: DogMan - 21 September 2022 20:31:47

Hello 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) For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47021.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: 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) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-3132-database-engine-error ------------------------------ BUTTONS: OK ------------------------------ What is wrong - do I need to specify the order of the files in teh restore?

Posted by: sirclesadmin - 21 September 2022 20:51:17
If you are restoring from a striped dataset to a new server or database then you must create a new database and then select the files as the source for the new database under devices. When you create the new database the SSMS will look through all of the files in the dataset to confirm that the retsore can complete and show the database as a resource able to be restored. You can then choose the time to restore the database to and if there is enough storage space the restore will contimue and complete. [attach]21[/attach]

Posted by: sirclesadmin - 21 September 2022 20:51:17

If you are restoring from a striped dataset to a new server or database then you must create a new database and then select the files as the source for the new database under devices. When you create the new database the SSMS will look through all of the files in the dataset to confirm that the retsore can complete and show the database as a resource able to be restored. You can then choose the time to restore the database to and if there is enough storage space the restore will contimue and complete. [attach]21[/attach]

Important Information: