Backing Up Guard1 Plus SE databases

Published: 2012-10-26

 

Last Updated: 2012-10-26

 

Applies To

Overview

It is important to maintain a current backup of your Guard1 Plus SE databases so that if the server should crash you will lose little or no data.

 

Recommendations

We recommend that you follow the guidelines as dictated by your IT department. If no such guidelines exist, we recommend the following minimum practices.

 

  1. Using SQL Management Studio, create a Data Maintenance Plan to automatically create a full backup of the Guard1 Plus SE databases daily. Data Maintenance Plans are not available in SQL Express versions; if you use SQL Express you need to manually backup your databases.
  2. Using SQL Management Studio, create a Data Maintenance Plan to automatically save the transaction logs every hour. If you download the PIPEs more frequently than once an hour, consider saving the transaction logs more often than once an hour.
  3. We do not recommend that you just save the .mdf file and .ldf files because backing up these files requires that you take the database offline.
  4. For more information on about creating SQL backups and Database Maintenance Plans, here are a few links:

 

http://msdn.microsoft.com/en-us/library/ms187510(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms191002(v=sql.105).aspx

http://www.simple-talk.com/sql/database-administration/7-preventable-backup-errors/

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.