You will need to use the SQL Server Enterprise Manager to backup your MS SQL Server 2005 based Globodox DB.
You will need to take a backup of...
The Master DB, i.e. MainDB and its Cache file i.e the MainDB_cache
And all your Globodox DBs along with their cache files
For each Globodox DB, you must also backup its linked folder which contains the File Store, by zipping it.
In the below example we are backing up the MainDB.
On the SQL Server machine we will back-up the...
MainDB and the MainDB_cache
Note: To completely backup a MS SQL SERVER 2005 DB you will need to backup the DB and also its Transaction logs.
AND
On the folder where Globodox Databases are located (this is usually the C:\Globodox Databases folder), we will back-up the MainDB sub-folder
To Backup a MS SQL Server 2005 based Globodox DB
| 1. | Make sure Globodox is not running. Click Start > All Programs > MS SQL Server 2005 > SQL Server Management Studio. The SQL Server Management Studio will now be launched. |
| 2. | Enter your login details and connect to the server. |
| 3. | Select the Databases folder in the left pane, all the databases will now be displayed in the right pane. |
| 4. | Select MainDB from the list. Right-click this database and select Tasks > Back Up... option. The Back Up Database window will be launched. |
| 5. | Select the Full option to perform a complete database backup from the Backup Type drop down. |
| 6. | Select the Database option from the Backup Component section. |
| 7. | Enter a name for the backup in the Name box. enter a short description about the Backup in the Description box. |
| 8. | Click the Add button to specify a destination for the backup. |
| 9. | Click the Options tab in the left pane. The options will now be displayed. |
| 10. | Select the Append to the existing backup set option to append the current backup to existing file or device. |
| 11. | Check the Verify backup upon completion option to verify the backup upon completion. |
| 12. | Click the OK button to begin the Backup. Once the backup is complete you will get a confirmation message, click OK. |
| 13. | Now, again right-click MainDB from the list and select Tasks > Back Up... option. The Back Up Database window will be launched. |
| 14. | Select the Transaction Log option to backup the DB's log from the Backup Type drop down. |
| 15. | Enter a name for the backup in the Name box. Enter a short description about the backup in the Description box. |
| 16. | Click the Add button to specify a destination for the backup. |
| 17. | Click the Options tab in the left pane. The options will now be displayed. |
| 18. | Select the Append to the existing backup set option to append the current backup to existing file or device. |
| 19. | Check the Verify backup upon completion option to verify the backup upon completion. |
| 20. | Click the OK button to begin the Backup. Once the backup is complete you will get a confirmation message, click OK. |
| 21. | Now, select MainDB_cache from the list and follow step 4-21 to backup this DB. |
| 22. | Once you have backed-up MainDB and MainDB_cache, close the SQL Server Management Studio. |
| 23. | Now, open the folder where Globodox Databases are located. This is usually the C:\Globodox Databases folder. (You can also backup the entire Globodox Databases folder by zipping it) |
| 24. | Locate the MainDB folder in the Globodox Databases folder. Now, zip this folder. |
| 25. | Open the the ITAZ\Globodox folder created under the folder designated as the Common Application Data folder in your Windows installation.
For Windows Vista/Windows 2008/Windows 7, this will be the C:\ProgramData\ITAZ\Globodox folder.
For Windows 2000/XP/2003 this will be C:\Documents and Settings\All Users\Application Data\ITAZ\Globodox |
| 26. | Locate the multi-user.gdx file and zip it. |
| 27. | Now, copy these files to a device (Pen Drive) or burn them on a CD. Follow the same steps to back-up other DB's
For more info on backup see, MS SQL Server 2005 Backup |
|
Notes:
Related Topics
Backup MS SQL Server 2000 DB
Backup MS SQL Server 2008 DB
Backup a MySQL based Globodox DB
Use the CD/DVD Module
Page URL:
https://www.globodox.com/support/help/index.htm?backup_mssql_server_2005.htm
