March 17, 2005 at 8:07 am
Hi
Is there any way to recover data after the Last TLog.?
for example I have full backup daily and Tlogs every 3 hours . My Last TLog is at 3:00 PM and My database went down at 4:00 PM how can I recover data after last TLog means data between 3:00 to 4:00 PM? Is there any way I can recover this data?
Thanks
Khalid
March 17, 2005 at 9:39 am
it all depends on the fact whether your transaction log file is available or not - in other words on the extent of the failure. For example:if your data files and tr.log files resided on different disks and only disks holding data files went down, you can recover all your transactions up to the point of failure. See 'How to restore to the point of failure' in Books online for the necessary steps. However this assumes that instance is up (system dbs are ok) and OS is ok. If this is not the case you will probably lose all transactions made after the last tr.log backup. One more thing If I'm not mistaken db must be in FULL recovery model, because in BULK-LOGGED you need datafiles to perform log backup.
March 17, 2005 at 10:20 am
Basically, you need to backup the current active log file so you'll have it available to restore after the older backups. Like Martin said, it depends on what was damaged.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply