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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-27 : 08:12:51
|
| fardy writes " Dear SQLserver Team, I'm facing a problem with sqlserver 2000. Yesterday I found a Corrupted database and a inconsistent table in other database. I Dealed With DBCC Checkdb to Analyze the Error for damaged table. I restarted my SQLserver in single user mode and Successfully Repaired it. About The Corrupted database , I use SP_RESETSTATUS to regain online status. The problem is that when I restart the computer The SQLserverAgent is on the wait for Recovery database ,While the SQLserver Service Has already finished restarting or ready For Client Connection. When I check the SQLserverAgent Error Log tab , On the Information select Combo. there's a message of information that says "Waiting for SQLserver to Recover Database ".I run my sql server Jobs and appear an error message "Cannot Run jobs while sql server Agent start". Could You Explain What's Wrong with The SQLSERVER JOBS , Have I managed the Errors Correctly ? Thank You very Much" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-10-27 : 11:40:14
|
| I suspect there is still something wrong with the databases.Create new databases and copy all the objects into them then delete the old ones.You should always do this if you find a problem with a database because you don't know what other undetected errors there are.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
My sqlserver jobs refuse to operate