Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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