July 30, 2007 at 6:05 am
Hi,
My laptop hanged as I was running a large table update and when I restarted my database was marked as 'SUSPECT'.
Running sp_resetstatus @dbname = "mydb" says that the flag has allready been reset but does not make any diffference.
When I try
SP_CONFIGURE 'allow updates', 1
RECONFIGURE WITH OVERRIDE
GO
UPDATE master..sysdatabases set status = -32768 WHERE name = 'mydb'
GO
SP_CONFIGURE 'allow updates', 0
RECONFIGURE WITH OVERRIDE
I get the error message
Update or insert of view or function 'master..sysdatabases' failed because it contains a derived or constant field.
Is there any other alternative to get into emergency mode to recover the data in the database?
Rgds and Thx
Christo
July 30, 2007 at 6:36 am
if it is a log corruption, you can rebuild the log. You will loose any transactions hanging around in it but will have most of your data back. Check google for DBCC REBUILD_LOG. There are many how to's
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply