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

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?
0
cchesnet
Asked:
cchesnet
  • 2
2 Solutions
 
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
 
BobPrinceExpertCommented:
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
 
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
 
TheMetrixCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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