Backup Exec 2012 taking forever to backup SQL 2008 DBs

Posted on 2013-06-25
Medium Priority
Last Modified: 2013-06-26
Our SQL database backups have gone from taking < 20 min to complete to several hours. The backup size remains the same, however the transfer rate to our Tandberg tape library has dropped considerably. This is after the backups were failing because of a redundancy check. We since have created a maintenance plan in SQL Management Studio to take care of that issue and also chose to ignore the checks in BE 2012. Now it backs up, but is incredibly slow.

This system is less than 6 months old.

We are a non-profit agency and was able to receive our Backup Exec 2012 software through Tech Soup. Because of this Symantec refuses to support it and will not even sell us support.

Any help will be appreciated.
Question by:ICantSee
  • 3
  • 2

Expert Comment

ID: 39274520
Hi - Can you give some more information on the setup?

What version of BE 2012 are you running. SP1 ?

Is the SQL server physical or virtual ? How is the library connected to the backup server?

Is it a full back up or incremental backup or both there is slow? Is it directly to tape or Duplicate from disc ?
If you open the Job history can you see any exceptions or errors in there? Are you backing up other servers with same issue on the same backup server?

Author Comment

ID: 39274566
It is running SP1a I believe. Live Update was failing so I manually downloaded the newest service pack and installed it. Now when I run Live Update it finds 1 update, SP1a and wants to download and install it. I say O.K., it fails... I don't know. It SHOULD already be SP1a. That's what I downloaded. (BE1798RSP1a_x64bit)

Our SQL Server is a Windows 2 node failover cluster (Hyper-V). It's operating system is Server 2008 R2 Enterprise Edition.

There was a card that came with the Tandberg tape library. I installed it in one of the hardware servers along with the BE 2012 software.

Both backup types are slow now.

Everything was running fine for a month and a half or so. Then I started getting "Database Redundancy Check failed" errors and the job would fail. We created a maintenance plan for the DBs and told BE 2012 to ignore the redundancy check error. Now the backups complete, but take forever. The data transfer rate is pathetic compared to what it used to be.

I am getting a "cannot access writer" error on my Exchange backup.

My data server backups and my SharePoint backups seem to be completing normally.
LVL 49

Expert Comment

ID: 39274602
can't comment on the details of your question, but perhaps you would be interested in this.

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. The solution is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical environments, and it is used in many organizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2012, 2011, and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free.
Ola Hallengren

also refer to
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_28163719.html#a39265474 and
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_28163719.html#a39265879 (if you do pursue this, do watch Ola's video)
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 39274609
Generally the Live update for Symantec is bugged - I normally have to download them manually and install as it fails stopping the services.

There is a bunch of hotfixes available try to search on the Symantec support site for issues with SP1a.

First make sure you are using the Symantec Tape drive drivers and not the vendors something  else. Check in device manager for the tape drive.

Afterwards open the job and de-select the databases and save job. Then open it again select the databases and save – Run job. - If that still give issues try add backup to disc folder and create a new job that points to there. Just to verify if the issue is with the connection to server or tape drive. Also plenty of reboots after driver installs etc.

Author Comment

ID: 39274876
Working on your suggestions.

I reinstalled the Symantec drivers for my tape library and rebooted the server.

I removed the database drives from the backup, saved it, then added them back in, saved and ran a differential. It's been queued for 33 minutes so far. Why does it do that? The correct tape has been loaded into the library drive. Why doesn't it just start writing?

Accepted Solution

DyneL earned 2000 total points
ID: 39275067
When you make changes that makes the tape library loose connectivity, even for a short period of time my experience tells me it's best to shutdown the BE server and restart the tape device - First when it's 100% ready turn on the server. If it keeps queening I would suggest the above.  Alternatively if you tape drive has a web interface login and see what the status is.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

578 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