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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With