Suspect SQL Database - HELP Needed - repost
This project received 14 bids from talented freelancers with an average bid price of $1648 USD.Get free quotes for a project like this
Project Budget$750 - $1500 USD
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)
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online