What folders to backup on MS SBS 2K

I have a SMB 2003 server running SQL & Exchange. I am using the backup software storegrid (vembu.com) and it does several backups alone:

exchange server
system state
registry

I am trying to configure the data backup of the server to backup and currently have it set to back up the entire server partition. I feel that I am backing up more then I need when I select this option.

Can someone advise me what folders I can skip when I run the backup of the server?
cchesnetAsked:
Who is Participating?
 
BobPrinceExpertConnect With a Mentor Commented:
You need to be very careful here with SQL database folders.
Depending on the backup system -the actual Database files will be skipped.
You have several choices in most cases:
1. Stop the SQL service prior to backup and restart after.
2. Run a SQL maintenance plan (job) to export the data to a backup file.
3. Use a Special Agent designed to backup SQL.
4. Some combination of the above (recommended).

There is also an Autoclose feature in SQL that can make the files available but that requires that the application that might have tables open,etc be closed - which can not always be guaranteed.
0
 
TheMetrixCommented:
I normall backup the following:

System State (has the registry in it)
Exchange Stores
SQL Database folders
any file server folders you may want backed up.

Although backing up the whole server isn't bad either but it does take more time and tape.
0
 
cchesnetAuthor Commented:
Ok, I have an SQL agent that will run and get the backup.

My main concern is what windows server folders/files are installed upon a reinstall of the server so I do not need to include them in by backup runs.
0
 
TheMetrixConnect With a Mentor Commented:
The only thing I backup from my DC's is the System State, that gets the Registry and Active Directory. If your DC also is a File Server you will of course want those files too.
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.

All Courses

From novice to tech pro — start learning today.