Yes. SQL Management Studio includes Backup and Restore functions.
triCerat, Inc. recommends regular backups of the Simplify database, and before all upgrades.
Follow these directions to backup the Simplify database without using replication:
1. Open Microsoft SQL Server Management Studio and Login.
Microsoft SQL Server Management Studio is a free add-on for Microsoft SQL Server available at www.microsoft.com
2. Find the Simplify database, right-click it, and select Tasks>Back Up...
3. Verify the Source, Backup set, and Destination. There are some useful options in the Options page (Verify Backup when finished and Perform Checksum before writing).
4. The Backup will be named Simplify (the same as the database source name) with a .bak extension into the Backup directory. This file needs to be Restored on a separate SQL Server, which can be accomplished by moving Simplify.bak to the target server.
Note: The remaining steps are used to restore the Simplify database. In this example the Simplify database was restored to a separate SQL Server for testing purposes.
5. Open Micorosoft SQL Server Management Studio on the new SQL Server and Login. Expand the instance, right-click the Database directory, and select Restore Database...
6. Complete the Restore Database form and select OK. The To database field must be named Simplify. Select From device and navigate to Simplify.bak.
7. The database has been moved, but more steps maybe required. You will need to return to the terminal server(s) and modify the Suite to connect to the new SQL Server. Open the Simplify Console, and under the file menu, go to Manage DSNs\System DSN (tab), find the "triCerat Simplify" entry and choose configure. Follow the screens to input the correct server name and credentials to connect with.
Finally, go back to the file menu and choose "Set Simplify DSN". Make sure that "triCerat Simplify" is selected. Then choose "Use specified credentials" and again provide the appropriate credentials with which to connect to the database. This will need to be performed on every server.
Additional Information
It is also possible to do a simple copy of both the database and the database log files, although the Backup & Restore functions are preferred.
If you are running the MSDE version of SQL server perform the following (Note – this procedure is best completed when users are not logged into the terminal server):
-
Go to the services control panel under Administrative Tools.
-
Stop the MSSQL$TRICERAT service.
-
Copy the “Simplify.mdf” and “Simplify_log.LDF” files from ‘C:\Program Files\Microsoft SQL Server\MSSQL$TRICERAT\Data’ to your backup location.
-
Restart the MSSQL$TRICERAT service.
If you are running a separate SQL server, perform the following (Note – this procedure is best completed when users are not logged into the terminal server. In addition, due to the possibility of other databases being in use, use caution when you are ready to begin this procedure):
-
Go to the services control panel under Administrative Tools.
-
Stop the MSSQLSERVER service.
-
Copy the “Simplify.mdf” and “Simplify_log.LDF” files from ‘C:\Program Files\Microsoft SQL Server\MSSQL$TRICERAT\Data’ to your backup location.
-
Restart the MSSQLSERVER service.