I am running SQL Server 2000. I was trying to implement a Database Maintence Plan to do the reorgznize data and index pages on database 'MYDB' and received the following error:
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
......
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.
Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment