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)
 master transaction log backup

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-11 : 08:45:29
Rosie writes "Since moving from SQL 7 to SQL 2000, the backup of the transaction log of the master database fails. I have tried running this via a maintenance plan and also using transact SQL. The log file is singularly unhelpful stating only "Backup can not be performed on database 'master'. This sub task is ignored." - Any ideas?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-01-11 : 08:46:03
Only full database backups can be performed on master. Books Online details this.
Go to Top of Page
   

- Advertisement -