Solved

Full backups with differential of sql databases not performing properly

Posted on 2011-03-25
13
1,381 Views
Last Modified: 2012-05-11
Greetings,
 VMware 4.0, SQL 2008, Backup Exec 2010 R2
This is what is happening: I run my full backup of the sql database on Saturday morning. Right after that I backup the virtual machine (the vmdk file) which from what is happening is triggering again another full backup of the sql database. So when my differential runs on Monday I get the following error:
'The Backup Exec SQL Agent was not used to create the last full, differential, or log backup of this database. You must use the SQL Agent to run a full backup before you can run a differential backup or transaction log backup.'
What it's boiled down to is the Backup Exec SQL agent does the full but then the VM causes a full too (I think) making the SQL agent think on Monday that something else has taken a backup. I have confirmed with the SQL guy that no other backups or maintenance plans are running on the database server. This also NEVER happened when I was using Backup Exec 12.5.
I could change the selection order in Backup Exec to have the SQL full backup go AFTER the VM is backed up but then it seems like overkill. Not sure what to do. I do have a ticket in with Symantec but we've been playing phone tag for a few days now so I'd see if anyone else had this problem.

Thanks all,
BW

P.S. What happened to the Backup Exec zone? Couldn't find it to add it.
0
Comment
Question by:bwinkworth
  • 7
  • 6
13 Comments
 
LVL 7

Expert Comment

by:lundnak
ID: 35215128
Could you check your SQL Server error log and see if you seeing a log entry for the SQL Full Backup at the time that the vmdk backup is occurring?
0
 

Author Comment

by:bwinkworth
ID: 35215760
I checked the logs. It shows @ around 12:25am that Backup Exec is backing up the sql databases with the message of 'Database backed up. Then @ 12:30am it starts with another message stating:
'I/O is frozen on database <databasename>' then
'I/O was resumed on database <databasename>'
The jobs don't over lap. It only takes Backup Exec about a minute to back them all up and then the VM gets backed up a few minutes later but it seems like it's resetting the databases somehow and messing up my differential on Monday-Thursday

Thanks,
BW
0
 
LVL 7

Expert Comment

by:lundnak
ID: 35215858
This is a stretch, but is the Backup Exec job configured to do a Copy-Only full backup?  Do you transaction log backups have the same issue as the differential backups?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:bwinkworth
ID: 35215890
Ah I looked a little farther in the logs and found that while the VM is being backed up there are a bunch of database entries that state:
'Database backed up. Database <databasename>, creation date.......blah blah blah device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {big long number} This is an informational message only. No user action is required'
So the VM is backing up the databases. But in the settings of the backup job on the vmware settings I have disabled GRT for sql databases.
What a pain
0
 

Author Comment

by:bwinkworth
ID: 35215936
The settings for the vmware stuff is set to 'Full' (that's the only setting there is)
See picture

Thanks lundnak
backup-settings.JPG
0
 
LVL 7

Accepted Solution

by:
lundnak earned 400 total points
ID: 35215944
Sounds like GRT is the problem.  Unfortunately, this will probably need a Symantec Support person to fix it.
0
 

Author Comment

by:bwinkworth
ID: 35215962
Ok that's what I thought. I'll let ya know how it goes. The guy is supposed to be calling me today
Thanks again
BW
0
 
LVL 7

Expert Comment

by:lundnak
ID: 35215966
Check out this article.
Did you click the Edit button to look at the individual application items?
0
 

Author Comment

by:bwinkworth
ID: 35216002
Can't see the article in your post :)
0
 
LVL 7

Expert Comment

by:lundnak
ID: 35216113
0
 

Author Comment

by:bwinkworth
ID: 35216207
Ah thanks. Yes I've got that all disabled. Just weird that I can't be the only one having this problem lol. I've googled for hours
Oh well I'll see what the symantec guy says. I'll keep you posted.

BW
0
 

Author Closing Comment

by:bwinkworth
ID: 35231765
Symantec's answer was to change the resource order so that the VM is backed up first and then have the sql full backup run right after it which is what I had done on Friday myself. But I had another failure on the weekend about my 2nd tape not being an LTO4 type tape so it quit lol. Yes it is an LTO4 because I've used it before.
Anyway thanks for the help fella.

BW
0
 
LVL 7

Expert Comment

by:lundnak
ID: 35232109
Unfortunately, that is not a great solution.  It seems like Backup Exec shouldn't backup the SQL Server if it isn't checked.

Any way, glad that it is working now.
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VMotion Direct Attached Storage 9 87
Amazon Glacier backup 6 37
TIVOLI FAILED REPORT FOR A NODE EVEN AFTER BACKUP MANUAL 2 26
VAAI  technology 2 57
If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question