Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
gustavouehara
Influencer
Posts: 19
Liked: 3 times
Joined: Dec 06, 2016 7:34 pm
Full Name: gustavo uehara
Contact:

SQL DB +TLOG truncate not working

Post by gustavouehara »

I need to backup sql db + truncate tlog each 1 hour

After install veeam agent at the db servers and configure Veeam server with an object storage as the backup repository the Full DB backup job ends OK.

-Parent Job backup: Volume C:\ and Volume G:\ (where DB + tlogs are located)
-App aware: DB Tlog Job backups run each 1 hour and truncate los correctly.

As Volume G: just have Database files I decided to remove it from Parent Job.
After removing Volume G:\ from (Filesystem Job ), Full DB Backup runs OK but Tlog backup each 1 hour stop running.

My Doubt if its necessary to configure backup Volume G: and "application aware" for sql and tlog backup ends correctly?



Thank you Sir
Dima P.
Product Manager
Posts: 14417
Liked: 1576 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL DB +TLOG truncate not working

Post by Dima P. » 1 person likes this post

Hello Gustavo,

Application aware processing for the database wont work if the database is excluded from processing, so, yes, you need to backup the underlying volume. Thanks!
gustavouehara
Influencer
Posts: 19
Liked: 3 times
Joined: Dec 06, 2016 7:34 pm
Full Name: gustavo uehara
Contact:

Re: SQL DB +TLOG truncate not working

Post by gustavouehara »

Hi Dima,
excellent

Thabk you for response!
Post Reply

Who is online

Users browsing this forum: No registered users and 24 guests