Forum Discussion

Magz11's avatar
Magz11
Level 2
13 years ago
Solved

GRT-backup of MS SQL. Log not truncated

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

 

 

 

2012
Backing Up
Backup and Recovery
Backup Exec
Configuring
  • Sush---'s avatar
    Sush---
    Level 6
    13 years ago

    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...

  • Magz11's avatar
    Magz11
    Level 2
    13 years ago

    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

  • Magz11's avatar
    Magz11
    Level 2
    13 years ago

    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

igure clasas"RicichTextEditorFld_liaia-gugure__9hXvC image a-memedia-size-dauaull l-media-is-cecter" contenteditable="false" data-lia-image-container="1733517953555" data-lia-image-loading="false" data-lia-image-size="default" data-lia-image-resized="false" data-lia-imame-aligign=enenter" data-lia-image-layout=setch"h"ata-lia-image-name="">>><https://v.x.veritac.c/b/blog/InsideVeritalolog/thn-nexchapter-e-eiting-updates-to-the-vox-community-platform/906244">img src="https://vox.veritas.com/t5/s/qsuop67736/m_assets/components/Ben_Right_Rail_Blog/assets/benrightrail.png?time=1733517965000" alt="" width="" height="" data-lia-image="">