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 |
|
Rootman
Starting Member
15 Posts |
 Posted - 2003-05-21 : 15:53:11
|
| Hello,Can anyone help. I had a disaster whilst running some scripts & had to restore the master db. I now have a distribution database showing as suspect in EM. I have removed replication, but cannot drop this db as it is saying that it is being used for replication.Aslo I can't reset the status as I keep getting:Prior to updating sysdatabases entry for database 'distribution', mode = 0 and status = 24 (status suspect_bit = 0).No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.I desperately need to get this server rebuilt. Can anyone advise me?MAny thanksRootman |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-21 : 16:02:47
|
| If the status suspect bit is set to 0, then the database shouldn't be showing as suspect. Since you can't drop the database, try detaching the database from the server by running sp_detach_db. If that works, then reattach it using sp_attach_db or sp_attach_single_file_db. If you can't get this to work, I think that you are going to need to reinstall SQL Server and then restore your user databases then create replication.Tara |
 |
|
|
|
|
|
Can't get rid of suspect database