Peruttu

Suspect SQL Database - HELP Needed

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ää: need sql help, suspect sql database help needed, 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

Tietoa työnantajasta:
( 18 arvostelua ) Istanbul, Turkey

Projektin tunnus: #4242278

1 freelancer is bidding on average $750 for this job

sirtacitllc

Hello, I have dealt with Suspect databases before. In reviewing your action steps above, it looks like you missed a few steps in recovering that database. Let me know if you would like my help. Thanks, Chris

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