Restore Database from suspect state.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian Zahn - 27 Jul 2008 11:25 GMT

I have a SQL server 2000, with a suspect database that has been detached.
Client has no backups. I have copied MDF and LDF files. I have tried to
attached database but get error 3456. Is there a way to recover from mdf &
ldf files?
Can I check state of files offline?

Reply to this Message

Uri Dimant - 27 Jul 2008 13:49 GMT

Ian
It does not gurantee that you will succeeded unfortunately

Stop SQL service, rename DbLive.mdf to DbBad.mdf.
started SQL service, created fake DbLive db (with log etc)
Stopped SQL service
Deleted DbLIve.mdf
Renamed DbBad.MDF to DbLive.MDF
Started SQL service.
Ran following script:
*/
ALTER DATABASE DbLive SET EMERGENCY
sp_dboption 'DbLive', 'single user', 'true'
DBCC CHECKDB ('DbLive', REPAIR_ALLOW_DATA_LOSS)
sp_dboption 'DbLive', 'single user', 'false'

>I have a SQL server 2000, with a suspect database that has been detached.
> Client has no backups. I have copied MDF and LDF files. I have tried to
> attached database but get error 3456. Is there a way to recover from mdf
> &
> ldf files?
> Can I check state of files offline?

Reply to this Message

Ian Zahn - 28 Jul 2008 06:09 GMT

Thanks, but this didn't work. I received an error It said error near
EMERGENCY??

Is there a way to restore an older mdf file then recover from ldf file, if
it id the mdf that is corrupt? It may be the ldf file that is corrupt.

> Ian
> It does not gurantee that you will succeeded unfortunately
[quoted text clipped - 18 lines]
> > ldf files?
> > Can I check state of files offline?

Reply to this Message