January 1, 2003 at 12:55 am
Hi,
I have a db with about 50 GB capacity. When I take a full backup of
this db on tape it takes about 7 or 8 hours (Ofcourse I do this just
once a week and dif. backup every night and trans. log backup every
hour) but during this process all my trans. log backup will be failed
and now this is my question: Can I trust this backup and what happen
when those trans. log backup fail. What happen if i want to restore to
a time during this full backup or Is it even possible?
SaNaZ
January 1, 2003 at 11:00 am
There is another thread on this somewhere but the gist is this.
Full Backup does not overwrite the transaction log so if you lose a Full backup but have the previous and all subsequent TL backups it will be fine.
Differential does not overwrite the TL log so go to the previous Full or Diff and use all TL backups last known good backup of Full or Diff.
TL backup does reset the TL log so loss of any TL backup makes all subsequent TL backups invlaid use a Full backup.
Based on that you can restore to a specific time as log as you have TL logs to the point after the last full or diff before that point.
Failed TL backup does not reset. You should try to find out why fails. ALso consider getting a faster Tape drive, and additional tape drive (you can span backups) or do backup to local drive (other than data or log drives for SQL items) and copy to tape. Later may benifit from purchase of a third party tool SQLZip or SQLLiteSpeed which both compress the files as making backups to local drive so then you have a smaller file to deal with.
January 2, 2003 at 5:49 am
s_atai,
I agree with Antares that you need to look into getting a faster tape drive or finding out why yours is so slow. I was backing up 190 GB of data in less than 6 hours.
As to why your Transaction Log backups are failing...you are probably only using one tape drive. With one drive you can't do more than one backup at a time, so all other jobs fail while the full backup is going.
Have you considered this....do all your backups to hard drive. Then use the tape drive to backup (copy) the .bak files to tape. You could run the tape backup once or twice a day and copy all of the .bak files at once. That's the way I do it.
-SQLBill
January 3, 2003 at 6:12 am
The transaction log dump cannot occur while a database backup is in progress. The failed dump you are experiencing does not break the chain of TL dumps because it never really got started.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply