Skip to Content
0
Oct 10, 2013 at 09:38 AM

Transaction Log Backup Scheduling Query - DB13

389 Views

Hi Basis Folks,

I want to schedule every hour Transaction Log Backups through DB13 where i want to get separate logs files for each hour to ensure point to point recovery.

option's that i am getting to schedule is Tape unload, Init, Format etc, so whichever options i choose it either appends or over rites the first Log file which it created. So through DB13 I am unable to generate multiple T-Log files for every hour.

OS - Windows

DB - SQL 2008

Please let me know whether its possible to generate multiple T-Log files on the same device through DB13, or we need to schedule through SQL Studio only.

Regards

Shyam Kumar