Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backing Up more than one database to a single device!

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-09 : 08:38:24
Nancy writes "Operating System - Windows 2000 Server
Service pack = 4.0

Trying to back up multiple databases to
one device, have been doing it forever
and one day it quits backing up. Here is the
error for one of the databases (the one that
was recently added)

Executed as user: BOB. The media set for database 'DBNAME' has 2 family members but only 1 are provided. All members must be provided. [SQLSTATE 42000] (Error 3132) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013) Associated statement is not prepared [SQLSTATE HY007] (Error 0) Cannot find file ID 35 on device 'd:\MSSQL\BACKUP\0neDump'. [SQLSTATE 42000] (Error 4038) VERIFY DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-09 : 16:41:47
What is the command that you ran?

Tara
Go to Top of Page
   

- Advertisement -