Back-up MS SQL Server 2008 DB

Print this Topic  Previous Topic Home Topic Next Topic
You are here: Back-up and Restore > Back-up Globodox DB > Back-up MS SQL-based Globodox DB >Back-up MS SQL Server 2008 DB

You will need to use the SQL Server Management Studio to backup your MS SQL Server 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 2008 DB you will need to back the DB and also its Transaction logs.

AND

In 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 2008 based Globodox DB

1.Make sure Globodox is not running. Click Start > All Programs > MS SQL Server 2008 > 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 the 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 the 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 logs from the Backup Type drop down.
15.Select the Database option from the Backup Component section.
16.Enter a name for the backup in the Name box. enter a short description about the backup in the Description box.
17.Click the Add button to specify a destination for the backup.
18.Click the Options tab in the left pane. The options will now be displayed.
19.Select the Append to the existing backup set option to append the current backup to existing file or device.
20.Check the Verify backup upon completion option to verify the backup upon completion.
21.Click the OK button to begin the backup. Once the backup is complete you will get a confirmation message, click OK.
22.Now, select MainDB_cache from the list and follow step 4-21 to backup this DB.
23.Once you have backed-up MainDB and MainDB_cache, close the SQL Server Management Studio.
24.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)
25.Locate the MainDB folder in the Globodox Databases folder. Now, zip this folder.
26.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
27.Locate the multi-user.gdx file and zip it.
28.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, Backup MS SQL Server 2008

 

Notes:

To restore a backed-up copy of MS SQL Server 2008 based Globodox DB see, Restore a Backed-up MS SQL Server 2008 DB

Related Topics
Backup MS SQL Server 2005 DB

Backup MS SQL Server 2000 DB

Backup a MySQL based Globodox DB
Use the CD/DVD Module

 
 

 


Page URL: http://www.itaz.com/globodox/help/index.htm?backup_ms_sql_server_2008.htm