Solved

SQL Databases and Symantec Backup Exec ISSUES

Posted on 2012-03-22
9
603 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
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…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

630 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