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