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:
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.