Using SQL Management Studio to Perform Data Maintenance Tasks in Guard1 Plus version 5.x

Published: 2017-03-01

 

Last Updated: 2017-03-01

 

Applies To

 

Introduction

The Data Maintenance Application allows you to archive your Guard1 Plus database. Archiving removes old data from the Master database and places this removed data in a separate, viewable Archive database. You will use SQL Server Management Studio to back up or restore the Guard1 Plus databases. A Backup of your database is a copy of your Master database. Restoring a database allows you to overwrite the Master database with a Backup file. For additional information from Microsoft about backing up and restoring databases, go to https://msdn.microsoft.com/en-us/library/ms187048.aspx .

 

By default, you will be reminded to back up your database every 30 days, and to archive the database every 180 days. You can modify these default settings through the Data Maintenance application. You can also refresh the reports and database procedures.

 

More Information

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.