How to backup and restore SourceAnywhere database in SQL Server Management Studio?



1.?Backup SourceAnywhere database through SQL Server Management Studio.


For this example, we will backup the database named "backmeup" to our "C:\backup" folder. Please be aware that the default database name of SourceAnywhere is "SourceAnywhere".

Once connected to your database server, you will need to browse to your database in the left window pane of Management Studio.

Right Click on your database, and under "Tasks" choose "Back Up..."

A new window will open where we will configure where to save the database backup file.

You will want to ensure that the "Backup type" is set to "Full" to get a Full backup of your database.

Now, highlight the Destination file that is already in the list by clicking on it, and Click "Remove".

Now, Click "Add..." to specify where to save the backup file.

A window will pop up, asking you where to save the backup file. Enter a location of your choice. For this example, we will save it to "C:\Backup\backmeup-Full-041608.bak".

Note that this is the entire actual filepath.

Now, we have to make sure that the backup you are creating overwrites all existing backup sets, as appending it to an existing set can cause conflicts when attempting to perform a restore. On the left-hand side of the window, click on 'Options', and then click on 'Overwrite all existing backup sets'.

Once this option is in place, all that is left to do is to run the backup! Click "OK" to begin the database backup.

If the database backed up successfully, you should receive a message as pictured.

2. Restore the database using the backup file.

Right click on "Databases", and choose "Restore Database".

A new window will open up, and you need to type a new database name, for example, "SourceAnywhere1". Then browse your computer to specify the location of the backup file.

Here the location is "C:\Backup".

After you add the backup file, make sure you tick the checkbox before you click "OK".

If the database has been restored successfully, you should receive a message as pictured below.

You might need to bind the database with your SourceAnywhere. You can achieve this by updating the database name in sawsconfigure.ini, which is under your installation folder.