• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

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

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
dougshepard
Asked:
dougshepard
  • 3
  • 2
2 Solutions
 
rindiCommented:
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
 
dougshepardAuthor Commented:
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
 
rindiCommented:
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
 
dougshepardAuthor Commented:
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
 
rindiCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now