Suspect SQL Database - HELP Needed - repost
$750-1500 USD
Paid on delivery
OS: Windows Server 2003
SQL: MSSQL Server 2005
[login to view URL] file is 13,4 GB
[login to view URL] 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)
DBCC checkdb('dbNAme')
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)
Project ID: #4242396
About the project
13 freelancers are bidding on average $1698 for this job
Freelance professional with 13 years experience with SQL Server systems. If I cannot fix your database, I doubt anyone can.
I believe I can help you. I've experienced types of "damages" myself after power downs, but always was a solution afterall.
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.
Hi, I am certified Microsoft Database administrator, and as Microsoft Solution Developer. I can help you with your problem, we can fix it in one day.
Hello, I can recover your database in suspect mode and get it backup and running. I am an expert Microsoft SQL Database administrator (I even passed the freelancer SQL Server Exam). Please send along the details so I More
Trust my job i am a System Admin & DB admin for past 9 years and i have come through lot of similar insidences
