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 Multiple Databases To one Tape

Author  Topic 

thomaspaul123
Starting Member

2 Posts

Posted - 2011-10-11 : 03:18:20
Dear Frenz,

I am trying to backup two databases to one tape drive suing the following command

------------------------------------
backup database DB1 to Tape0 with init
go
backup database DB2 to Tape0
go
---------------------------------------------
and i am getting the error like

Processed 258320 pages for database 'DB1', file 'DB1_Data' on file 1.
Processed 6 pages for database 'DB1', file 'DB1_Log' on file 1.
BACKUP DATABASE successfully processed 258326 pages in 981.001 seconds (2.157 MB/sec).
Server: Msg 4027, Level 16, State 1, Line 1
Mount tape for BACKUP DATABASE of database 'DB2'.

----------------------------------------------
Please Help my Tape is ejecting after backing up thew first Database

   

- Advertisement -