Remove suspect databases
Posted on 2004-11-27
I have an urgent problem I need help with!!
Last night we lost power and our SQL server kicked out without shutting down properly.
When the server came back this morning, the distribution and my_dbase databases were both marked as 'Suspect'. I cant delete the my_dbase and recreate it as it is being used for replication. I can remove the replication from the server becuase the distribution database is suspect. Ive tried using sp_resetstatus on both, but that doent help.
I dont have a backup of the distribution database, but I can recreate the replications if I have to. i do have a backup of the my_dbase database, so that can be restored OK.
Please help me fix my replication!!!