August 16, 2003 at 12:42 am
Out Corporate SQL Database appear Supspect!
i have already do it follow steps:
run sp_resetstatus 'NVS'
stop MS SQLServer
restart MS SQLServer
but it appear again!
how do i do it ?
error information:
Server: Msg 906, Level 22, State 2, Line 1
Could not locate row in sysobjects for system catalog 'Sysobjects' in database 'NVS'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.
I love Database administrate job!
August 16, 2003 at 4:23 am
It appears your database is truly corrupted and attempts to reset the status will not be successful (as you've found out).
Do you have a recent full backup to restore from?
Were there any actions undertaken (eg. detach/attach) leading up to the suspect status occurring?
Cheers,
- Mark
Cheers,
- Mark
August 18, 2003 at 1:20 am
Hi,
If you haven't a recent backup then you can do the following.
Look in you logs first, to see if is autorecovering. If nothing is in the logs, run sp_who2 to see if there is a rollback on the db in question. If there is leave it it will 'hopefully' recover.
If not, and as reset status will not work you'll have to set the db to emergency mode
update sysdatabases
set status = 32768
Then set the db to single user
exec sp_dboption 'yourdb', 'single user', 'true'
Then run dbcc checkdb ('yourdb', REPAIR_REBUILD)
Set single user to false.
Hopefully this will work, it has for me a few times.
Good luck!!
Ritch
"I didn't do anything it just got complicated" - M Edwards
"I didn't do anything it just got complicated" - M Edwards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply