Implementing a backup plan

Backing up your iMIS database ensures that your data is secure; having a solid monthly routine in place minimizes the amount of data you could lose in a disaster.

Tip: Avoid using third-party backup SQL agents, which may cause problems when restoring your database.

Initial backup tasks

• Schedule SQL Server Agent to backup your iMIS database nightly.
• Configure the nightly backup to save the backup file (*.bak) to tape.
• Set up SQL Server Agent to notify you if the backup fails.

Monthly backup tasks

• Each month, test your backups: restore the file to a temporary database, open iMIS on it, and verify that it works.
• Once the backup is verified, pull a tape from the rotation and store it off-site, as a fail-safe.