Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Databases and Symantec Backup Exec ISSUES

Posted on 2012-03-22
9
Medium Priority
?
613 Views
Last Modified: 2012-12-13
We have a Symantec Backup Exec SQL job that does nightly diffs and weekly full backups.  Backup Exec was giving this warning after our jobs "Database is configured to maintain transaction logs.  Transaction log backups are not being performed.  This will result in the log growing to fill all available disk space.  Regular log backups should be scheduled or the database should be changed to the simple recovery mode."
In order to resolve this, we created another job in Backup Exec using the "Log - Back up Transaction Log".
The strange thing now is that after these jobs run, both the Database and Logs grow after the backups run which has caused the disk to run out of space.
Any ideas.
0
Comment
Question by:bermudahs
  • 4
  • 3
9 Comments
 
LVL 16

Expert Comment

by:DcpKing
ID: 37755570
OK: so you're doing a backup of your database and you're also doing a backup of the transaction log ("T-Log").

The database probably grows slowly, but most of its work is selects, updates, and deletes, none of which add to the size. The T-Log, OTOH, records everything the database will do before it does it, so continually grows, as you've seen!

When you do a backup of the T-Log you can then truncate it off - there's no point in keeping two copies! - and get it back down to size.

I'd recommend you study this by Microsoft - it explains why:
http://msdn.microsoft.com/en-us/library/ms189085.aspx
and this one explains how:
http://msdn.microsoft.com/en-us/library/aa174524%28v=sql.80%29.aspx

Hopefully these will get you up to speed on what you've been missing. Good luck!
0
 

Author Comment

by:bermudahs
ID: 37755601
Maybe this is something I need to ask Symantec.  I run my database backup and then run the log backup and after doing so, my database and logs grow in size right after the backup.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 37755648
I'm not personally familiar with Symantec Backup Exec, but I took a quick look at their web page and it took a bit of digging to discover that they do claim to back up SQL Server databases.
However, I rather suspect that they're doing it as a part of backing up your whole hard drive, whereas the backup operations of SQL Server (or any other database) are also a part of keeping it healthy, as well as safe from loss of data, and are not confined to just copying off the data, as I hope you realised from reading the references I gave above.

I'd strongly suggest you get an experienced DBA in to assist you with understanding just what you need to do, etc. There are lots of agencies that would be more than happy to take your money and provide you with someone, or else you can look for your local chapter of PASS (Professional Association for SQL Server), contact them, and ask if you can arrange for assistance and advice from them. Their web site is http://www.sqlpass.org/.

Good luck!
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

by:bermudahs
ID: 37785189
I've requested that this question be deleted for the following reason:

Not a valid response
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 37785190
I have no objection to the question being closed and getting no points (I'm not doing this for the  points), but I am interested in why it's considered "not a valid response". Perhaps bermudahs would like to elaborate on this - for my own education of nothing else.
0
 

Accepted Solution

by:
bermudahs earned 0 total points
ID: 37786988
resolved by modifying the SQL maintenance plans.
0
 

Author Closing Comment

by:bermudahs
ID: 37805074
Resolved myself.
0
 

Expert Comment

by:pajce
ID: 38687553
I am aware zou resolved it yourself but please can you share your solution with the rest of us? I mean that is this forum for..

Thank you in advance.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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.
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…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

971 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