June 15, 2004 at 11:44 am
I have a Database on a 7.0 instance that I had locked down in single-user/read only mode. When I try and take it out of single-user/read only mode, the Database goes into SUSPECT mode and I cannot access it at all. Can anyone help??
June 15, 2004 at 1:45 pm
Did you do this from a SQL 2000 Enterprise Manager? I have experienced this with "offline", which is not supported in 7.0.
You might try using sp_resetstatus to reset the suspect status.
See "Resetting the Suspect Status" in 7.0 books online.
Steve
June 15, 2004 at 1:55 pm
Yes, That must be what happened. I have sql server 2000 tools on my desktop. Thank you!
June 15, 2004 at 2:01 pm
I haven't seen many issues managing 7.0 with 2000 tools, but there are a few!
Hope the sp_resetstatus works for you.
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply