Be sure SQL logs are truncated when using Veeam backup

To be sure that application aware backup really truncate sql logs file pls fallow

First on log files of Veeam backup you can not find such information %allusersprofile%\Veeam\Backup

You have to go Windows logs , Applications tab , source should be MSSQLSERVER

You should see first process like below

I/O is frozen on database DB1. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.

Then this

I/O was resumed on database DB1. No user action is required.

Backup Process

Database backed up. Database: DB1, creation date(time): 2012/12/07(14:59:40), pages dumped: 9665, first LSN: 519:339:1, last LSN: 519:341:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {‘{5A6DFFD2-352D-4329-BB2F-5E95F3064ADB}1’}). This is an informational message only. No user action is required.

And log truncation process

Log was backed up. Database: DB1, creation date(time): 2012/12/07(14:59:40), first LSN: 346:177:1, last LSN: 519:351:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {‘NUL’}). This is an informational message only. No user action is required.

If someone know to check with other way pls add a command.

VM

Posted on 10/12/2012, in Veeam and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: