Hi,
I wanted to create a second backup of my database. So on the Back Up Database - MyDatabase (that you can bring up by Tasks -> Backup) I clicked on Add button. Then I entered a different file name, Test.bak. So now I have two names in the Destination window. But when SSMS starts making backup I get the following message:
System.Data.SqlClient.SqlError: The volume on device 'c:\program files\microsoft sql server\mssql2\
mssql\backups\MyDatabaseName.bak' is not part of a multiple family media set.
BACKUP WITH FORMAT can be used to form a new media set.
The odd thing is that the message (above) refers to the "standard" backup name (MyDatabaseName.bak) and not the new name I just entered.
What am I missing?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham