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.4.
This help file does not exist in MainBoss 4.2.4, but the index for that version 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 >