cancel
Showing results for 
Search instead for 
Did you mean: 

GRT-backup of MS SQL. Log not truncated

Magz11
Level 2

We are using BE 2012 to back up several SQL 2008 servers running on Windows 2008 R2 VM's on Hyper-V. We use Hyper-V GRT Backup to do the backup, incremental every weekday and full every weekend. The BE-Agent is installed on the VM's and the SQL-Agent is licensed on the media-server.

I thought the SQL transaction logs would be truncated in this scenario, but they are not.

In the backup logs I get the V-79-57344-38728 error message, but it does not help me to figure this out.

In the BE 2012 Admin Guide it says: "Note: Backup Exec uses the Microsoft Hyper-V writer during backups of VSS-aware

applications on virtual machines. The Microsoft Hyper-V writer truncates
application logs before data is moved to the storage device. Therefore, the
application logs for the applications on the virtual machines are truncated if you
use Microsoft Hyper-V.
"
 
So I am wondering:
1. Should the transaction logs be truncated when doing a hyper-v GRT backup or not?
2. If they should, why don't they?
 
Kind Regards
Magz

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

PraveenShetty
Moderator
Moderator
Employee Accredited Certified

Please refer to this technote : http://www.symantec.com/docs/TECH137587

Thanks

 

 

 

View solution in original post

5 REPLIES 5

Sush---
Level 6
Employee Accredited Certified

Have you looked at this technote?

http://www.symantec.com/docs/TECH128944 : Backup completes with exceptions if the SQL database resides on a virtual server.

 

Thanks,

-Sush...

Kiran_Bandi
Level 6
Partner Accredited

Have you seen this TN: http://www.symantec.com/docs/TECH128944 

Magz11
Level 2

Hello Sush..

According to the article, it is not possible to truncate SQL-logs with a GRT-backup. 

But why is the BE 2012 Administrators guide saying that application logs will be truncated on VSS-aware applications in VM's on Hyper-V (page 807)?

 

Kind Regards

Magz

PraveenShetty
Moderator
Moderator
Employee Accredited Certified

Please refer to this technote : http://www.symantec.com/docs/TECH137587

Thanks

 

 

 

Magz11
Level 2

Thanks,

But I still do not understand why the BE 2012 Administrators guide is saying that application logs will be truncated on VSS-aware applications in VM's on Hyper-V (page 807)?

Kind Regards

Magz