Suljettu

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)

Taidot: Tietokannan hallinto, SQL, Windows Server

Näytä lisää: sql suspect, need sql help, windows power user, backup database, need access database help, sql server attachment, hours access database, user mode, command help, database results error, 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, help manual, sql query help

About the Employer:
( 18 reviews ) Istanbul, Turkey

Projektin tunnus: #4242396

14 freelanceria on tarjonnut keskimäärin 1648 $ tähän työhön

qualifiedcoders

Hi We are interested in your project and read your requirements.We have completed 150+ big projects in last 5 years. Please check private message board for details.

1500 $ USD 20 päivässä
(1 arvostelu)
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 4 päivässä
(14 arvostelua)
4.6
wavesl

I can help you

750 $ USD 7 päivässä
(3 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0
pentium10

Professional work from professionals!

7500 $ USD 30 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 Lisää

1000 $ USD 3 päivässä
(0 arvostelua)
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 Lisää

1000 $ USD 1 päivässä
(1 arvostelu)
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 13 päivässä
(0 arvostelua)
0.0
nvenky2010

interested on this project

800 $ USD 10 päivässä
(0 arvostelua)
0.0
absseo

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

750 $ USD 25 päivässä
(0 arvostelua)
0.0
enmesh

Pls chk pmb

1500 $ USD 10 päivässä
(0 arvostelua)
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 Lisää

1600 $ USD 25 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0