Backing up SOS Collab Data

The Microsoft Data Engine (MSDE) and MS SQL Server have a command tool that can be used to back up and restore the SOS Collab database.

(Please note: The SOS Collab Servers directory does not contain any project data. All information is stored in the SQL database, which is in your SQL installation folder.)

The SOS Collab database consists of the 'ggdata' database and file attachments.

• Backing up the 'ggdata' database to a location to disk
• Backing up the file attachments
• Restoring SourceOffsite Collab Data and File Attachments
• Additional Information

(Please Note: This procedure does not back up the Visual SourceSafe database.)

Backing up the 'ggdata' database to a location to disk

The SQL database can be backed up using the osql utility that ships with MSDE and MS SQL Server. The username and password used with the osql utility should be the username 'sa' and the 'sa' password. Note that osql commands are case sensitive.

1. From a command prompt, launch the osql.exe using the following command:
   
   osql -Usa -P<sa_password>
   
   
2. Type the following commands at the prompts. Note that the path to the backup location should be surrounded by single quotes.
   
   1> BACKUP DATABASE ggdata TO DISK = '<file_path>'
   (enter)
   2> GO
   (enter)
   
   The file_path should be the full path to an existing folder. The path to the backup location on disk should include the name of the backup file with a '.dat' extension. An example backup file path would be 'c:\backups\ggdata.dat'.

Backing up the file attachments

Copy the 'attach' folder to a backup location. The 'attach' folder is located in the SourceOffSite Collab Servers directory (SourceOffSite Collab Servers\Data\Attach). The default location for this folder is:

c:\Program Files\Sourceoffsite Collab Servers\Data\Attach.

Restoring SourceOffsite Collab Data and File Attachments

To restore the SourceOffSite Collab installation, you must restore the 'ggdata' database, and the file attachments.

Restoring the 'ggdata' database to a location from disk

1. From a command prompt, launch the osql.exe using the following command:
   
   osql -Usa -P<sa_password>
   
   
2. Type the following commands at the prompts. Note that the path to the backup location should be surrounded by single quotes.
   
   1> RESTORE DATABASE ggdata FROM DISK = '<file_path>'
   (enter)
   2> GO
   (enter)

The file_path should be the full path to the backup folder. The path to the backup location should include the name of the backup file which will have a '.dat' extension.

Restoring the file attachments

Copy the 'attach' folder from the backup location to the SourceOffSite Collab Servers\Data (SourceOffSite Collab Servers\Data\Attach) directory.

Additional Information

Additional information on using the osql.exe utility to back up and restore a Microsoft Data Engine Database including backing up and restoring the database to and from TAPE can be found at the following URL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2krk/html/75t2_6.asp