Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Backups: How to Schedule log no truncate method

Created: 03 Aug 2012
Parkar's picture
1 Agree
0 Disagree
+1 1 Vote
Login to vote

Hello;

I want to backup SQL logs via log no truncate method. the DBA team asked to perform hourly log backups without truncation. i am using BE 2012-SP1a & log no truncate method option available only in " ONE TIME BACKUP WINDOW".. in otherway i can perform hourly log backups via incremental, which truncates the logs. is there a way to schedule log no truncate methode. secondly below comments for my other forum created for the same.

https://www-secure.symantec.com/connect/forums/sql-backups-log-truncation#new

SQL 2008 R2 with Full & Simple Recovery Model for different servers.

Needs your suggestions.

Thanks