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 a database in a tape device

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-21 : 22:33:40
Sriram writes "I've got SQL Server 7.0(SP 2) running on Windows NT 4.0(SP 5). There are 5 databases running on SQL and a backup of all these databases is scheduled to run automatically after office hours. The backup does happen, but when I try to restore a database thro Enterprise Manager and choose the option "From Device" and click on "View Contents", the backups in the tape are listed without a backup set name. However, when I take a manual backup by choosing the option "Backup Database", the backup set names are listed perfectly. I think the problem must be in the way I set up the Maintenance Plan for automatic backup. Could u help me?"
   

- Advertisement -