Closed

Suspect SQL Database - HELP Needed - repost

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)

Skills: Database Administration, SQL, Windows Server

See more: sql suspect, need sql help, windows power user, help & manual, backup database, need access database help, sql server attachment, hours access database, user mode, command help, database results error, server set windows server 2013, 2013 query, query mssql, set server 2013, backup mssql, error executing database query, windows server 2012 professional, access sql query, sql query access, sql server command, windows server 2013, access database check, emergency mode, database mssql

About the Employer:
( 18 reviews ) Istanbul, Turkey

Project ID: #4242396

14 freelancers are bidding on average $1648 for this job

qualifiedcoders

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.

$1500 USD in 20 days
(1 Review)
4.6
weonlydo

Freelance professional with 13 years experience with SQL Server systems. If I cannot fix your database, I doubt anyone can.

$800 USD in 4 days
(14 Reviews)
4.6
wavesl

I can help you

$750 USD in 7 days
(3 Reviews)
2.2
adiconstantin80

I believe I can help you. I've experienced types of "damages" myself after power downs, but always was a solution afterall.

$1500 USD in 1 day
(0 Reviews)
0.0
pentium10

Professional work from professionals!

$7500 USD in 30 days
(0 Reviews)
0.0
yosall

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.

$2000 USD in 1 day
(0 Reviews)
0.0
sirtacitllc

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

$1000 USD in 3 days
(0 Reviews)
0.0
Itdap

Hello Sir, My name is Diego and I have 14 year of IT experience. I have the following certifications: MCITP, MCP, MCTS and STS also coursed CCNA, MCSE and MCDBA. I provide all kind of support services including: Micr More

$1000 USD in 1 day
(1 Review)
0.0
techwelfare

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.

$877 USD in 13 days
(0 Reviews)
0.0
nvenky2010

interested on this project

$800 USD in 10 days
(0 Reviews)
0.0
absseo

Hi, Please check detailed bid in teh PMB. Thanks, Sridhar

$750 USD in 25 days
(0 Reviews)
0.0
enmesh

Pls chk pmb

$1500 USD in 10 days
(0 Reviews)
0.0
tsbcrop

********** HOPE TO GRAB YOUR ATTENTION ********** We have recently done exactly one similar application, with lot more features than listed in this project description. We have done plenty of such apps in the past. Ple More

$1600 USD in 25 days
(0 Reviews)
0.0
karthikv92

Trust my job i am a System Admin & DB admin for past 9 years and i have come through lot of similar insidences

$1500 USD in 1 day
(0 Reviews)
0.0