I need to make a usable copy of an SQL Server database on Windows Server 2003 for testing purposes. There is a backup tool built into Enterprise Manager but I can't seem to make it work.
I've tried "Right-click on database -> All Tasks -> Add... -> Enter a new name D:\Whatever\ 20110803.bak -> OK
but got the message
Microsoft SQL-DMO (OCBD SQLSTATE:42000)
The volume on device "D:\whatever\ preexistant.bak is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set.
BACKUP DATABASE is terminating abnormally | OK
Q: What is a multiple family media set and why do I need the old existing backup file to be a multiple family media set if I'm creating a new backup?
Q: What is BACKUP WITH FORMAT? I'm pretty sure I don't want to format anything. Again, I'm trying to create a new backup file.
I click OK and see that a new destination has appeared in the Destination list, so I Select it and click OK.
I get the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot open backup device "D:\whatever\ preexistant.bak. Device error or device off-line. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally. | OK
Q: Wherer are whese error logs?