Transaction log backup every 30 mins?

[isonlyme]

Hi guys,

i want to do transaction log backup for an audit but my software conflicts with the directory of the transaction log in prod so I want to schedule another backup after 30 minutes from the original transaction backup in prod to capture the data from my new directory.

Qustion if i have a 10:00 transaction log and i create another at 10:30, this 10:30 log backup will contain the data also from the 10:00 backup?

thanks in advanced

 

[mrdenny]

No, transaction log backups have the data from the most recent log backup to current.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com