June 27, 2007 at 10:55 am
Hi,
I have a replicated database that is marked load/suspect because a restore was interrupted after being started by mistake ( by me ). I cannot enter any commands against it because the system thinks it is being restored. For example to remove it from replication, etc. Any ideas on how I can take care of this problem? Thanks.
June 28, 2007 at 1:17 am
sp_resetstatus against the database to bring that online.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 3:24 am
Can we assume that the restore was successfully rolled back??
June 28, 2007 at 3:34 am
If the restore is terminated abruptly in middle then database being resotred will go to loading state and you will need to restore the full backup copy again to bring it online.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply