Solved

How Can i exclude a database from windows 2008 SBS Backup

Posted on 2010-09-10
9
579 Views
Last Modified: 2012-05-10
Hi i have 2008 standard running and i am using the built in backup
I normally use this as im happy to backup everything and it works well
However i have a database that according to the support people say must not be backed up directly and must be exluded from the main backup or it will get corrupted
There is a built in app in the database to back it up to a file then let windows back it up.
I can only see how to exclude a whole drive from windows backup and only if it hasnt windows on it.
How can i exclude this database from the backup
0
Comment
Question by:dougdog
  • 5
  • 4
9 Comments
 
LVL 2

Expert Comment

by:boxerenterprises
ID: 33644649
You can't exclude the database only in Windows backup. I doubt very much that it will be corrupted by being backed up.

I suspect what they mean, is that you cannot recover from a backup taken that way without risking corruption. Sage for instance should be backed up be running the programs own routine and then taking a backup of the backup file created by Sage. If you backup the database files directly you may have data corruption when you try and restore from the backup.
0
 

Author Comment

by:dougdog
ID: 33645897
the provider say it will corrupt it at some point and strongly advice not to backup this way
0
 
LVL 2

Expert Comment

by:boxerenterprises
ID: 33645970
They have a very strange program. You will have to set the backup manually then. The SBS backup does not allow you to exclude certain folders.

Use Windows backup to select the folders you want included and create a schedule (remember to include the system state and Microsoft Exchange in the backup)
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:dougdog
ID: 33646035
how would i do it manually
i agree crazy  program
0
 
LVL 2

Expert Comment

by:boxerenterprises
ID: 33646147
0
 

Author Comment

by:dougdog
ID: 33646606
any other options
0
 
LVL 2

Accepted Solution

by:
boxerenterprises earned 500 total points
ID: 33646839
Only other option is to move the application to a partition on its own where you could exlude it, or you could use a 3rd party application such as Symantec Backup Exec to backup. Or even better an online backup service that is Exchange aware such as www.boxerbackup.co.uk
0
 

Author Comment

by:dougdog
ID: 33646938
or just back it up anyway maybe there just being over carefull
0
 

Author Closing Comment

by:dougdog
ID: 33690773
cheers
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

803 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