Video Screencast Help

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


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.

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

Needs your suggestions.