Closed

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
Employer working
Project Budget
$750 - $1500 USD
Total Bids
14
Project Description

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)
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)

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online