This topic will discuss how to restore previously created backups of your Total Office Manager database using the (provided) Enterprise Server Utility.
(Note: This topic ONLY covers restoring backups created using the Enterprise Server Utility. Backups created by any other means or otherwise cannot be restored using the Enterprise Server Utility are not covered here. Please speak with your company IT professional for more information about restoring backups created using any means other than the Enterprise Server Utility.)
The Enterprise Server Utility is a tool that is installed along with the Server Components required to properly use Total Office Manager and can be found on your company server (i.e. database host machine). Either locate the shortcut icon on the server’s desktop or go to Start | All Programs | Aptora | Total Office Manager | Enterprise Server Utility.
- For Windows Vista, 7, and Server 2008 users it is highly recommended that your run the utility “As Administrator”. To do so, right-click on the Server Utility icon and choose “Run As Administrator”.
Immediately when you launch the utility you will be presented with the “Establish SQL Server Connection” window. Use the “Instance Name” drop down to select your SQL instance.
In the Authentication Method field, you may simply use Windows Authentication to connect without error. If your SQL Server instance has been manually configured it may be necessary to use “SQL Authentication”. This method requires a username and password.
- The username is normally ‘sa’ (which should appear by default)
- The password is set up during installationIf you do not know your SQL username or password, please speak with your IT professional or whoever installed SQL and/or Total Office Manager for your company. Aptora does not have any means to recover or reset this password.
Once you have your Instance Name and Authentication Method chose, click the [Connect] button.
When restoring your database you have the option to restore it to a NEW database (which can exist alongside an existing version of your live database) or overwrite your current live database.
- To begin creating your backup, click the [Restore from Backup] button.
- Select the preferred restore option.
-To overwrite an existing database with the backup, select the existing database (e.g. Blank Company) and lick [Continue].-To restore to a new database, select the <Restore to New Database…> option and click [Continue].
- Select the backup file you wish to restore and click [Open].
- A small window indicating the restoration process has begun will appear. Be sure to let this finish before closing the program, even if the program becomes unresponsive.
- Once the restore is complete, you can close the Enterprise Server Utility.
- It is recommended that you do not store your backups on the same system as the live database (i.e. the Server)
- It is recommended that you create regular backups (e.g. Daily, Weekly, Monthly, etc.) and before performing any updates to the Total Office Manager software.
- For Windows Vista, 7, and Server 2008 users – If you have any problems launching or connecting to the Enterprise Server Utility, right-click on the utility icon and choose “Run As Administrator”.