Solved

SQL Databases and Symantec Backup Exec ISSUES

Posted on 2012-03-22
9
576 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

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

Not a valid response
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 16

Expert Comment

by:DcpKing
Comment Utility
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
Comment Utility
resolved by modifying the SQL maintenance plans.
0
 

Author Closing Comment

by:bermudahs
Comment Utility
Resolved myself.
0
 

Expert Comment

by:pajce
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now