Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.
Course Of The Month
4 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Full backups with differential of sql databases not performing properly
Posted on 2011-03-25
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
7
6
13 Comments
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?
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
'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
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?
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
'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
The settings for the vmware stuff is set to 'Full' (that's the only setting there is)
See picture
Thanks lundnak
backup-settings.JPG
See picture
Thanks lundnak
backup-settings.JPG
Sounds like GRT is the problem. Unfortunately, this will probably need a Symantec Support person to fix it.
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
Thanks again
BW
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
Oh well I'll see what the symantec guy says. I'll keep you posted.
BW
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
Anyway thanks for the help fella.
BW
Featured Post
IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| VM Backups are failing with the following error VDDK Error: 20005 | 6 | 32 | |
| What to monitor when using VCenter Server Linux Appliance ? | 2 | 100 | |
| Recovering deleted VM in vSphere 6.x | 5 | 78 | |
| T-SQL: need to reset a declared variable | 4 | 33 |
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed."
When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs.
Launch Data Protection Manager from the deskt…
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…
Suggested Courses
Course of the Month4 days, 22 hours left to enroll
739 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.