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
Solved

Legato  SQL Backups

Posted on 2006-07-13
5
440 Views
Last Modified: 2008-01-09
Hello,
         I am using Legato for my backups. I am trying to set up a backup strategy for my SQL data bases which include a daily full and an hourly incremental....  There are 30 DB's most of them are not used but maintained for histrorical purposes....  The full backup is 156GB in size..   One hour later using Legato networker 7.2  The incremental size was 51GB in size..   and every hour after that it was the same size  Can some tell me why, with no changes to the DB's  The Legato backup size is so large      Is there a way to reduce the size?
0
Comment
Question by:Cecilpierce
  • 3
  • 2
5 Comments
 
LVL 55

Accepted Solution

by:
andyalder earned 500 total points
ID: 17102003
First problem is that it's not possible to do normal incremental or differential backups of SQL (or other transactional databases) so what they do instead is a full backup of the transaction logs and not backup the database.

Second problem is the way SQL (assuming MS SQL) allows transaction log files to grow indefinitely by default instead of occasionally creating a new log file.

Ckeck the logfile sizes and to shrink them create a new transaction log for each one and then run dbcc shrnkdb. The creating a new logfile speeds up the process mentioned on Q11 of http://support.microsoft.com/kb/195760/en-us. Some SQL versions allow you to shrink the file with a maintenance job created under enterprise manager instead of issuing the SQL command. Note the command is shrinkdatabase in some versions.
0
 

Author Comment

by:Cecilpierce
ID: 17102706
Thank you,  not exactly what I wanted to hear.  need to figure out another way
0
 
LVL 55

Expert Comment

by:andyalder
ID: 17102863
Don't understand why it isn't what you want to hear. Are the transaction logs 51GB in size or did I guess wrong?

Once you've got the logfiles down to a few meg the incrementals will be much quicker and the backup software agent won't have any problems keeping them small. Logfiles grow and grow until a full backup is done and I'm assuming yours hasn't been backed up for ages.

Once it has taken a full backup it should shrink the transaction logs automatically so the incrementals get much smaller but sometimes the logfiles get so big that the backup software can't do it and you have to do it manually. After that there's an option on the agent to truncate the log automatically.
0
 

Author Comment

by:Cecilpierce
ID: 17103999
Don't get me wrong,,,   I'm new in the arena and struggling with trying to find a way to reclaim disk space. We currently use the sql backup and store the the .BAK and TRN files on disk.  If I can find a way to to use Legato as the only backup solution I can free up some space...   I'm using SQL 2000   Thank You very much

I also have a 15TB EMC Clariion CDL which is where I was going to store the backups for quick recovery.


any ideas are welcome

I am new at this,,  brought in to learn the backups..  so, my knowledge of the big picture is minimal.
0
 
LVL 55

Expert Comment

by:andyalder
ID: 17110739
If you're struggling to recover disk space then what I said in the first post ought to gain you nearly 50GB in a couple of days if the transaction logs really are that size, please confirm whether between them they add up to 51GB or not.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

839 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