Solved

SQL Databases and Symantec Backup Exec ISSUES

Posted on 2012-03-22
9
588 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 to return specific rows and columns, with various degrees of sorting and limits in place.

816 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

8 Experts available now in Live!

Get 1:1 Help Now