Backing Up Transaction Logs to Tape?

Posted by David Stein on Server Fault See other posts from Server Fault or by David Stein
Published on 2010-05-03T19:20:17Z Indexed on 2010/05/03 20:28 UTC
Read the original article Hit count: 335

Filed under:

I'm about to put my database in Full Recovery Model and start taking transaction log backups. I am taking a full nightly backup to another server and later in the evening this file and many others are backed up to tape.

My question is this. I will take hourly (or more if necessary) t-log backups and store them on the other server as well. However, if my full backups are passing DBCC and integrity checks, do I need to put my T-Logs on tape?

If someone wants point in time recovery to yesterday at 2pm, I would need the previous full backup and the transaction logs. However, other than that case, if I know my full back ups are good, is there value in keeping the previous day's transaction log backups?

Backing Up Transaction Logs to Tape?

Posted by David Stein on Stack Overflow See other posts from Stack Overflow or by David Stein
Published on 2010-05-03T19:20:17Z Indexed on 2010/05/03 19:48 UTC
Read the original article Hit count: 334

Filed under:

sql-server

|

sql-server-2008

|

sql-server-2000

I'm about to put my database in Full Recovery Model and start taking transaction log backups. I am taking a full nightly backup to another server and later in the evening this file and many others are backed up to tape.

My question is this. I will take hourly (or more if necessary) t-log backups and store them on the other server as well. However, if my full backups are passing DBCC and integrity checks, do I need to put my T-Logs on tape?

If someone wants point in time recovery to yesterday at 2pm, I would need the previous full backup and the transaction logs. However, other than that case, if I know my full back ups are good, is there value in keeping the previous day's transaction log backups?

Developer IT