Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup has corrupted .. need to get full recovery for the database Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 12:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 27, 2014 6:10 AM
Points: 104, Visits: 400
I am taking backups regularly without any issue, suddenly I noticed backup is failed in one day and checked DBCC executed on database. I got result as fatal corruption in the database. In this situation i went for previous day backup to restore the database ( as per the MS recommendation... we will try to restore the DB from the previous good backups.. ) but unfortunately the backup found having issues and its not avalid backup to restore.

So i checked before the previous day backup ( 2 days back) is available but don't have t-log backups after this full backups.

Can some body please advise what is best options to recovery my database as full recovery...
Post #1475281
Posted Friday, July 19, 2013 1:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 42,481, Visits: 35,550
Chances are you're not going to be able to recover fully.

Please run the following and post the full and complete, unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS




Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1475304
Posted Friday, July 19, 2013 3:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 27, 2014 6:10 AM
Points: 104, Visits: 400
Thank U for your reply :)

I don't have that database available now due to it was restored with the available backups.. but still i want to know the best possible alternatives here.. Please advise !!!
Post #1475335
Posted Friday, July 19, 2013 3:55 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 42,481, Visits: 35,550
Without seeing the corruption messages, I can't advise in detail, but if the corruption was fatal, then the only option would have been to restore the latest usable backup. With no log backups, that would mean loss of all data since then, but nothing more is possible with the backup strategy you have there.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1475340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse