May 30, 2011 at 9:49 am
I require some clarification. I run full backup every day @ 12:01AM. Diff Backup at 6hrs interval and tran backup hourly.
My last tran backup was at say 11AM. At 11:35AM, my database gets corrupted and I have restored tran backup upto 11AM.
Now what? Is there any chance of getting any part of the data of those 35 mins.
I tried to take tran backup at 11:35 after I sensed DB corruption but that backup didn't happen.
May 30, 2011 at 10:04 am
If the ldf is still available and SQL is still running then you should be able to. You'll need to use a specifc option on the log backup - WITH NOTRUNCATE - as normal log backups require that the DB is available.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply