Backing up the HelpSTAR Database

 

Overview:

 

Previously accessible in an installation outside of the Windows Client, Database Administration can now be located on the Setup/Administration tab.  These tools allow you to run immediate or scheduled backups of your SQL 2005 or 2008 database.  Backups are dynamic, so they can occur while the database is active. A backup captures the data as it is at the moment the statement is executed; no partial transactions are reflected in the backup database.  Performing a backup can slow the system, so you may want to schedule a backup for a time when the database usage is low.

 

 

  1.  
1. Ribbon Toolbar

 

 

Manage Jobs

 

Backup

 

  

 

View

 

 

  1. 2. Database Backup Jobs

     

     

  1. 3. General Backup Properties

 

 

Note: The physical location of the backup file is important. The backup file needs to be placed under any of the directories on the machine (server) where the SQL 2005/2008 server is running. The backup tool prevents the user from selecting a location that is not accessible to the SQL server. Since the backup file resides on the local drives of the server machine, it is necessary to back up the backup file to tape or to another location on the network (a small batch file to copy the backup file would be sufficient). The backup file can also be backed up by other third party backup utilities.

 

 

  1. 4. Schedule Backup Properties

 

Set a scheduled interval for when you wish to the database backup to be performed.

 

 

 

        5. How to Create a New Database Backup

 

To create a new database backup, perform the following:

  1.  

                                

 

 

Back to top 

See Also:            

Authentication

Backup File Manager