November 27, 2007 at 9:36 am
SQL: sql server 2000 std
OS: windows 2003 std
I did a restore of a 66 gig database to a test SQL server, it seemed to of completed the restore fine, however, when looking at the restored database its greyed out and says (Loading) next to the database name, when I try to delete the database it says "cannot delete database NAME its been used for replication" ?? But there is no replication set up!
I've stopped / started the SQL services and rebooted the server once.. but I still cant delete it,, HELP!!
many thanks
Dave
November 28, 2007 at 2:07 am
If your database still has the status loading, you probably didn't select the recovery option when restoring the backup. Start antother restore and make sure you've select RECOVERY option.
The message about replication can be caused because the database had been replicated before and the metadata clean-up in the distribution database was not succesfull.First make sure that your database is accessible again. Then try to remove replication.
Markus
[font="Verdana"]Markus Bohse[/font]
November 28, 2007 at 2:13 am
Stop and re-start the MS-SQL Server Service thro' windows service manager.
November 28, 2007 at 3:54 am
Hi MarkusB,
Thanks for the suggestion, it seens to be overwriting it...
fingers crossed.
Cheers
Dave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply