August 29, 2007 at 8:28 am
Hi friends,
My database had this require ment
Every day my database 12;00pm we will take fullbackup
1:00 O clock differntial backup
2:00 O clok again on diifferntial backup
Every 15(fifteen)Min we will take Transaction log backups
My database is crashed on 2:00 clock we will not take 2:00 clock Tlog backup
we have taken only 1:45 Tlog backup.
Here my database is loss 1:45 to 2:00 clock data
we cannot take this 15min Tlog backup
Any body plz give suggestion on how to recover this 15min data plz help me it very urgent
Regurds
subu
August 29, 2007 at 9:04 am
From what I'm gathering here, you're database went down prior to your 2:00 backup running and the last backup that you have is the 1:45 backup. You can only recover up to the last backup that you have. Transaction log backups allow you to do a point in time recovery, but your backup must span past the point in time to where you want to recover. For you to be able to recover to 2:00, you would need to have a backup at 2:00 or later to use to recover. Your backup/recover plan should take into account the balance between how much data you can stand to lose versus how long you can afford to be down while running your recovery. In your case, you are going to lose 15 minutes worth of data. You will have to restore to the 1:45 backup and all data that was input/manipulated between 1:45 and 2:00 will need to be redone by the users.
August 29, 2007 at 10:41 am
I think some another procedure is there to restore that 15 min Tlog backup can u plz explain me how to restore the 15 min Tlog Data plz
August 29, 2007 at 11:01 am
not sure if you have taken Tail log backup & restore with Recovery.
August 29, 2007 at 3:36 pm
If you can take a backup after the "went down" part, that is your "tail" and you can use it to restore to a point in time right before the crash. I you can't then you are out of luck and all you can do is restore up untill that last differential.
* Noel
August 30, 2007 at 1:00 am
Hi,
You can recover to a point in time by recovering only the transactions that occurred before a specific point in time within a transaction log backup, rather than the entire backup. By viewing the header information of each transaction log backup or the information in the backupset table in msdb, you can quickly identify which backup contains the time to which you want to restore the database. You then need only apply transaction log backups up to that point.
Check in BOL: Point-In-Time
Regards
Kumar
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply