DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS) gives errors

[omacron]

Hi

I have a MS SQL MSDE database that came up in suspect mode. I am trying to get a backup copy but it will take some time. Meanwhile I want to try to fix it. Switch the database to Emergency Mode and ran;

DBCC checkdb('dbname')

It showed some errors in two tables. So switched the database to single user mode. Then ran this;

DBCC CheckDB ('dbname', REPAIR_ALLOW_DATA_LOSS)

It gave me the following error;

Msg 3908, Level 16, State 1, Line 1
Could not run BEGIN TRANSACTION in database 'SS1' because the database is in bypass recovery mode.

I don't know how to get past this. Tried running this but didn't help;

update sysdatabases
set status = status = 24
where name = 'dbname'

Any help would be great.

 

[mrdenny]

Try setting the status to 65544 and the status2 to 1627389952 and see if that helps. Does the database show as online in the UI?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog