?
Solved

Veritas Backup - select both HDs, shares, and SQL... am I wasting space?

Posted on 2006-05-19
5
Medium Priority
?
321 Views
Last Modified: 2013-12-01
I am using Veritas Backup Exec to backup my servers.  I backup critical data daily and then backup everything weekly.  For my weekly backups, if I select everything will I end up wasting space on the tapes due to picking things more than once.  By this I mean if I select everything it includes both hard drives, all shares, SQL, and the SQL data located on the hard drive.

So should I unselect the shares and unselect the folder where the SQL data is stored to avoid duplicate data or does Veritas figure that out for me?

Or, if I select SQL but not the data folder do I actually miss the data?

Thanks

Doug
0
Comment
Question by:dougshepard
  • 3
  • 2
5 Comments
 
LVL 88

Accepted Solution

by:
rindi earned 2000 total points
ID: 16719098
There is no point backing up the OS or the programs. What needs to be backed up is the data and the system state. If you have the appropriate agents, you'll see the SQL database as a backup object, as well as the exchange information store, so with those agents you don't backup the SQL files or Exchange files. That wouldn't work anyway unless you stopped those services before backing up. The systemstate includes data like active directory info etc, so that is important too.
0
 

Author Comment

by:dougshepard
ID: 16719124
So in the event of a complete server failure I would have to reinstall Windows and Programs from scratch and then restore the system state and data?

Or would system state include Windows and Programs?

Thanks

Doug
0
 
LVL 88

Assisted Solution

by:rindi
rindi earned 2000 total points
ID: 16719188
You'd reinstall windows and software from scratch, then restore system state and data. You could use a tool like acronis trueimage server to make a snapshot of the system with software so the reinstallation goes faster, and then after having restored those snapshot images restore the systemstate and data. But such an image you only need one or two, or when you change something major on the server. These don't belong into a regular backup scheme.
0
 

Author Comment

by:dougshepard
ID: 16719251
What about Symantec Ghost to get everything?

What is a system state exactly?  What all does it include (you said AD information.. but what else?).  Is it for the OS only or does include anything related to programs?

Thanks

Doug
0
 
LVL 88

Expert Comment

by:rindi
ID: 16719297
Ghost is possible, but I don't like symantec products, so I never recommend that!

System State includes AD, System Settings, Shadow Copies, registry settings etc. That means that program info that is stored in the registry is included.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

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

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
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
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…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

864 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