Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server Backup error - not part of a multiple family media set [closed]

I am trying to backup my SQL Server 2008 R2 database. However I am getting the below error, no matter where I try to save the backup.

System.Data.SqlClient.SqlError: The volume on device 'D:\Programfiles\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\dbName.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. (Microsoft.SqlServer.Smo).

Can anyone throw light on this?

The only helpful links I could google were following but of little use:

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/a1eb2818-2a97-4c52-aa8d-7c224f1ac282

and

http://www.sqlservercentral.com/Forums/Topic279584-24-1.aspx

like image 441
Yoosaf Abdulla Avatar asked Dec 10 '12 19:12

Yoosaf Abdulla


1 Answers

I wasn't able to reproduce the issue however, here's a workaround for whoever might run into this: use WITH FORMAT clause or Options - Back up to a new media set and erase all existing backup sets option in the GUI.

like image 63
Serge Belov Avatar answered Sep 25 '22 06:09

Serge Belov