Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Symantec Backup Exec SQL backup 3.5 times larger

Posted on 2011-03-14
9
Medium Priority
?
380 Views
Last Modified: 2012-05-11
I am running Symantec Backup Exec 12d on Server 2003.  It is backing up two SQL 2000 instances running on Server 2003 x64.

The first one appears to work correctly, the backup and database sizes are nearly identical.  However, the other database is backing up 3.5x MORE data than actually in the database(s).  The final backup is showing at nearly 230GB while the sum of the databases is only about 65GB.

This is eating through my tapes rather quickly as well as causing this backup to run significantly longer then expected.
0
Comment
Question by:americaneldercare
[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
  • 6
  • 2
9 Comments
 
LVL 7

Expert Comment

by:Cboudroz
ID: 35130913
is it possible that you are using the option "Append to the existing backup set"?
0
 

Author Comment

by:americaneldercare
ID: 35131227
We are using that option, however I am under the impression that is allowing it to append to the existing tape - not increase the actual size of the current backup it is recording.

To make sure we are speaking of the same thing, I am referring to the actual "byte count" of the individual backup, not the total GB consumed on the backup media.  The "Byte count" on the differential based backup is showing as 266GB - when I check the details, it is indicating that ~228GB of that is coming from a database which only totals 65GB, another 37GB is coming from a database totaling ~40GB, and the remainder from a few folder (these don't change often so under a differential only a few 100 MB's are written).

A full backup of the same system, using the same selections, and also tagged as 'append to media, overwrite if not appendable media is available' totals only 104GB.
0
 

Author Comment

by:americaneldercare
ID: 35131477
I am testing putting this backup job on hold and creating a new one as a copy off of the "Full" which, as indicated, appears to be functioning correctly.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 7

Expert Comment

by:Cboudroz
ID: 35131496
are you dropping to the same tape in both example?
0
 

Author Comment

by:americaneldercare
ID: 35131529
No, we have a tape library.  Certain tapes are designated for Full and others Differential, and the individual jobs are designated to use their appropriate tape sets.
0
 
LVL 56

Expert Comment

by:andyalder
ID: 35141867
Sounds like a problem with the selection list, you might have the physical file as well as the database that lives in that file selected for example. Text view rather than the graphical view readily shows the difference if there is one.
0
 

Author Comment

by:americaneldercare
ID: 35165186
the "new" job created by copying the Full is working correctly.  Compared the text view of selections as well as the 'View Summary' between the original and current Differential backups - only difference currently is the old one had "Advanced Open File" on.  enabled for the new one, will see if the next differential (monday) runs any different.

otherwise, it appears that *something* is just corrupt with the original backup.
0
 

Accepted Solution

by:
americaneldercare earned 0 total points
ID: 35207875
it appears the 'Advanced Open File' is causing an issue.  The backups prior to me turning it on were working fine, after I turned it on we are having the issue again.  Turning it off again.
0
 

Author Closing Comment

by:americaneldercare
ID: 35910039
not sure why the Advanced Open File option causes this issue, but not using it resolves the problem.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

609 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