How to handle SQL transaction logs via Veeam backup

VMware specific discussions

How to handle SQL transaction logs via Veeam backup

Veeam Logoby stanleymok » Mon May 30, 2016 6:25 am

Hi all,

As I am using Veeam & Replication v9 to backup SQL server database, and I have some question about this...

1. How Veeam to handle truncate logs action?

2. What method does Veeam to use?

3. Once truncated logs to Veeam backup, are these logs will Increment?

4. Any other permission setup in SQL database?

Thanks a lots,

Stanley
stanleymok
Novice
 
Posts: 8
Liked: never
Joined: Fri May 13, 2016 3:54 am

Re: How to handle SQL transaction logs via Veeam backup

Veeam Logoby PTide » Mon May 30, 2016 9:43 am

Hi,

How Veeam to handle truncate logs action?
That depends on what truncation option you choose.

What method does Veeam to use?
Not sure what you mean, could you please elaborate?

Once truncated logs to Veeam backup, are these logs will Increment?
If you are asking if the copies of logs inside the backup will increment, then the answer is "No". Logs are stored as a separate set of files thus each new log backup session will create a new log backup file in the repository.

Any other permission setup in SQL database?
Please see this article (the very bottom of it).

Thanks
PTide
Veeam Software
 
Posts: 3017
Liked: 245 times
Joined: Tue May 19, 2015 1:46 pm

Re: How to handle SQL transaction logs via Veeam backup

Veeam Logoby stanleymok » Tue May 31, 2016 3:22 am

Hi PTide,

Thank you for your reply, for P2, I would like to know what method (like copy and move, cut action) to handle SQL transaction logs in database and Veeam backup? Besides, once truncate logs is complete, SQL database size will decrease, right?

Thanks a lots,

Stanley
stanleymok
Novice
 
Posts: 8
Liked: never
Joined: Fri May 13, 2016 3:54 am

Re: How to handle SQL transaction logs via Veeam backup

Veeam Logoby PTide » Tue May 31, 2016 5:03 pm

I would like to know what method (like copy and move, cut action) to handle SQL transaction logs in database and Veeam backup?
That depends on job's Guest Processing settings.

Besides, once truncate logs is complete, SQL database size will decrease, right?
Database and transaction log are two different things. Log truncation will free logical log space, but neither database nor physical log file will get smaller. Please take a look at this article for details.

Thanks.
PTide
Veeam Software
 
Posts: 3017
Liked: 245 times
Joined: Tue May 19, 2015 1:46 pm


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 25 guests