You have chosen to sponsor your bid up to a maximum amount of .
OS: Windows Server 2003
SQL: MSSQL Server 2005
dbname.mdf file is 13,4 GB
dbname_log.LDF file is 1,7 GB
We saw that our database became to "suspect" mode after a power cut.
We executed this query;
EXEC sp_resetstatus 'dbName'
and this quert;
ALTER DATABASE dbName SET EMERGENCY ;
to set the database to emergeny mode.
At this stage, we stopped sql server and took manual backups of .mdf and .ldf files.
We started sql server again and performed a db check by executing this query; (results are at the attachment)
And we modified database to single-user mode from properties>options>restrict access.
Then we executed this command to repair the database;
DBCC CheckDB ('dbName', REPAIR_ALLOW_DATA_LOSS)
After 17 hours, we got error. Error message is at the attachment.
We need professional help for repairing / rescueing.
(PS: Our last regular DB backup was performed at June 2012)