Unable to Backup Master Database

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)

Unable to Backup Master Database

Author

Topic

mani36
Starting Member

2 Posts

Posted - 2002-05-07 : 15:50:40

Hi,

When I backup the master database (SQL Server 7), I get the following Error:

SQL-DMO (ODBC SQLState: 42000)
Backup, CHECKALLOC, bulk copy, SELECT INTO, and the file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.
Backup or restore operation terminating abnormally.

I appreciate any suggestion that will help me resolve this issue.

Thanks
Mani

Edited by - mani36 on 05/07/2002 15:54:54

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-05-07 : 16:43:18

here
here and
here

<O>

mani36
Starting Member

2 Posts

Posted - 2002-05-08 : 11:06:08

Hi,

Your tips were useful. There was a hung BACKUP process. Once I killed it, my BACKUP procedure worked fine. Once again thanks for the replies. Keep up the good work.

Thanks
Mani

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources