Backup has corrupted .. need to get full recovery for the database
-
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...
-
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_ERRORMSGSGail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
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 !!!
-
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply