Backup and Restore > Manually backup a Sohodox DB

You are here: Backup and Restore >Manually backup a Sohodox DB

You will need to use the SQL Server Management Studio to manually backup your MS SQL Server based Sohodox DB.

You will need to take a backup of...
MainDB_sdx and its Cache file i.e the MainDB_sdx_cache

You must also backup the File Store (the linked folder) , by zipping it.

In the example below we are backing up the MainDB.

MainDB_sdx and the MainDB_sdx_cache

Note: To completely backup a MS SQL SERVER 2012 DB you will need to back the DB and also its Transaction logs.

AND

In the folder where Sohodox Databases are located (this is usually the C:\Sohodox Databases folder), we will back-up the MainDB sub-folder

To manually backup the Sohodox DB:

1.	Make sure Sohodox is not running. Click Start > All Programs > MS SQL Server 2012 > 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_sdx from the list. Right-click this database and select Tasks > Backup Database... option.

5.	The Backup Database window will be launched.

6.	Select the Database. Select the Backup Type as Full.

7.	Click the Add button to specify a destination for the backup.

8.	Click the Options tab. The options will now be displayed.

9.	Select the Append to existing backup set option to append the current backup to existing file or device.

10.	Check the Verify backup upon completion option to verify the backup upon completion.

11.	Click the OK button to begin the Backup. Once the backup is complete you will get a confirmation message, click OK.

12.	Now, select MainDB_sdx_cache from the list and follow step 4-11 to backup this DB.

13.	Once you have backed-up MainDB_sdx and MainDB_sdx_cache, close the SQL Server Management Studio.

14.	Now, open the folder where Sohodox Databases are located. This is usually the C:\Sohodox Databases folder. (You can also backup the entire Sohodox Databases folder by zipping it)

15.	Locate the MainDB folder in the Sohodox Databases folder. Now, zip this folder.

16.

Open the the ITAZ\Sohodox 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\Sohodox folder.
For Windows 2000/XP/2003 this will be C:\Documents and Settings\All Users\Application Data\ITAZ\Sohodox

17.	Locate the multi-user.gdx file and zip it.

18.	Now, copy these two files to a device (Pen Drive) or burn them on a CD

•	To restore a backed-up copy of the DB see, Restore a backed-up DB