Backups with SQL Express

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.2.
For the latest version of this help file can be found here.

< Previous section  |  Table of Contents  |  Index  |  Next section >

Maintenance plans aren't available with SQL Express. For information on automatic backups with SQL Server Express, see

http://www.sqldbatips.com/showarticle.asp?ID=27

Otherwise, just use the backup facilities within MainBoss.

Important: By default, SQL Server configures itself so that backup files are written to the same folder as the databases themselves. This offers no protection against hardware errors—if you get a disk crash on the disk that holds the databases, you'll lose the backup files too. Therefore, you should configure SQL Server so that backup files are written to a completely different device, preferably on a completely different computer.

Ideally, you should make copies of your backup files and keep those copies off your premises. That way you don't lose data if there's a fire or some other disaster that affects your entire site.

< Previous section  |  Table of Contents  |  Index  |  Next section >