OS: Windows Server 2003
SQL: MSSQL Server 2005
[url removed, login to view] file is 13,4 GB
[url removed, login to view] 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)
14 freelancers are bidding on average $1648 for this job
Hi We are interested in your project and read your [url removed, login to view] have completed 150+ big projects in last 5 years. Please check private message board for details.
Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.