While investigating a technical support issue for Snow Commander, the need may arise to restore your Microsoft SQL database. To do so, you will use Microsoft SQL Server Management Studio. If you did not install this when you installed SQL, you can install it from the original source.
 

Alternatively, you can download Management Studio Express, and use it to run the queries.

Connecting to Your Database

Follow the procedure below to connect to your Snow Software® Commander® database.

1. Login to a computer where SQL Server Management Studio is installed.
2. Launch SQL Management Studio from the Start menu.
3. Choose Database Engine as the Server type, choose the correct Server Name from the list or browse for the correct server.
     
   If your user account has rights to access the database, leave Authentication as Windows Authentication. Otherwise, switch it to SQL Server Authentication and enter the User name and Password for a SQL account with rights to access the database. If you are not sure which account to use, you can confirm what’s being used by Embotics vCommander by opening the vCommander Control Panel .
4. Click Connect.

Restoring the Database

Now that you are connected, you can proceed with restoring the database. Before you begin the next procedure, make sure that you have access to as much disk space as is required for the backup file.

1. If Commander is currently running, you will need to stop the service before you can complete the restore. To do so, issue the command services.msc from the Start menu on the Commander application server.
2. From the list of services, right-click Commander and click Stop.
3. Back in SQL Management Studio, right-click your Commander database and choose Tasks > Restore > Database….
4. The Restore Database dialog opens. On the General page, choose From device and click 
5. The Specify Backup dialog opens. Click Add.
6. Browse to and select the backup file. Click OK.
7. Back in the Restore Database dialog, confirm that the To database: and To a point in time: settings suit your needs and select the checkbox for the backup set you want to restore.
8. Switch to the Option page. Check Overwrite the existing database (WITH REPLACE) and click OK.
9. When backing up a database to provide to Embotics technical support, the default options are sufficient.  Note the location where the backup file will be created, listed under the Destination section, and click OK. 
10. Click OK when the restore completes.

See Also

• Choosing a Recovery Model for Your Database
• Backing Up the Commander Database Using SQL Management Studio