Backups with SQL Express

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

Maintenance plans aren't available with SQL Express. We recommend that you 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 >