Solved

SQL Databases and Symantec Backup Exec ISSUES

Posted on 2012-03-22
9
600 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
[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
  • 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

738 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