October 31, 2002 at 9:20 pm
Hi all,
One of the database on my server
was marked suspect. I was able to get
into normal mode.
But when I try to access the tables i get
error 926.
Is this because I have not re started the
server
November 1, 2002 at 4:44 am
From SQL BOL
quote:
sp_resetstatus turns off the suspect flag on a database. This procedure updates the mode and status columns of the named database in sysdatabases. The SQL Server error log should be consulted and all problems resolved before running this procedure. Stop and restart SQL Server after executing sp_resetstatus.
Check the Error Log to see what errors cause it to mark as suspect and do restart the server to complete recovery. May go back to suspect if issues were not resolved.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply