I had a HDD failure that caused the database to become SUSPECT. Thats ok we have backups to fall back on. Restoring the database failed because the database is used for repliacation, the database status was set to LOADING (in middle of restore). Because of this status I am unable to remove the repliaction to allow the database restore.
Whats a way to change the database status from loading? Or is there any way of removing it completely and starting again from a backup? Can I force repliaction to be removed?
Thanks for taking the time to look at my problem, all help and suggestions are much appreciated.
Thanks for the advise, though I am not running SQL 2005(running SQL Server 2000 32-bit) and the stored procedure recommended in the linked artical - sp_removedbreplication does not have the @force parameter in versions before 2005.
Is there a way of getting the T-SQL for the new sp_removedbreplication? Or a different approach is needed?