March 23, 2010 at 7:32 pm
Will Legato's backup sequence be affected by regular native Transaction Log backup?
After taking a Full backup from Legato, and subsequent TK backups from Legato, if a DBA just makes an ad-hoc TL backup, will legato recognize it, or will it's sequence be broken?
Dan.
March 25, 2010 at 6:50 am
Legato won't 'have' it - it'll just be wherever you backed it up to, not in Legato's store. So yes, the sequence will be broken as far as your Legato setup is concerned
March 25, 2010 at 9:16 am
But when you have to do a point in time recovery, if I move the TL backup that was done to the Legato's store, will it recognize the sequence, then, if you do according to the timestamp?
March 25, 2010 at 9:34 am
repent_kog_is_near (3/25/2010)
But when you have to do a point in time recovery, if I move the TL backup that was done to the Legato's store, will it recognize the sequence, then, if you do according to the timestamp?
Good question. Unfortunately it is a good question that exceeds my knowledge of the product I'm afraid.
Put it this way though - it's not something I'd try on a production system. I'm a bit baffled as to why you'd want to take an out of sequence TL backup outwith your scheduled Legato backups tbh. What are you going to do with it?
May 27, 2010 at 4:23 am
I use EMC Networker as following:
- Take full and differential backups with Legato to VTL
- Take transaction log backups to disk with SQL Server utilities
- Transfer transaction log backups from disk to VTL with Networker
If point-in-time recovery is needed I restore from Networker with no recovery option and then I apply transaction logs from SQL Server.
The product works fine with SQL Server 2000. In SQL Server 2005 I can't take differential backups for databases in full recovery model. This is a Networker's bug that is fixed in release 7.6 if I remember well.
PSA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply