Restoring the firm database using Microsoft SQL Server Management Studio

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

In Accounting CS, data for all of your firm's clients is stored in a single SQL database. Therefore, when you use Microsoft SQL Server Management Studio Express to restore client data, the application restores data for all clients in the database. In Accounting CS, the likelihood of data for a single client becoming corrupt is very low; therefore, backing up and restoring data for clients individually would be an ineffective defense against data corruption, hardware failure, or a similar scenario.

In most cases you would not need to use the following restore procedures. However, if the situation arises, you can follow these steps to install the Microsoft SQL Server Management Studio Express application and restore your firm's data from there.

Note: You can use Microsoft SQL Server Management Studio to restore the entire firm database, but not data for a single client. For help with backing up and restoring individual clients, see Backing up and restoring data for a client via the Client Data Management Utility.

Installing SQL Server Management Studio 2008 R2

Use the following procedure to install the SQL Server Management Studio Express 2008 R2 application on your server.

  1. Visit http://www.microsoft.com/en-us/download/details.aspx?id=22985.
  2. Select a language and then click the Continue button.
  3. Select the version of SQL Server Management Studio and click Next.
    • If you are running a 32-bit version of Microsoft SQL Server, select the SQLManagementStudio_x86_ENU.exe file.
    • If you are running a 64-bit version of Microsoft SQL Server, select the SQLManagementStudio_x64_ENU.exe file.
  4. After the download is complete, navigate to and double-click the EXE file to begin the installation.

Installing SQL Server Management Studio 2012 Express

Use the following procedure to install the SQL Server Management Studio 2012 Express application on your server.

  1. Visit https://www.microsoft.com/en-us/download/details.aspx?id=29062.
  2. Select a language and then click the Download button.
  3. Select the SQLManagementStudio_x64_ENU.exe version of SQL Server Management Studio and click Next.
  4. After the download is complete, navigate to and double-click the EXE file to begin the installation.

Notes

  • If you are working in a Windows 10 environment, we recommend that you install SQL Server 2012 or later. For details, visit https://support.microsoft.com/en-us/kb/2681562.
  • If you need assistance with installing Microsoft SQL Management Studio, please contact a qualified IT professional. Our Support department is unable to assist with this installation.

Restoring a database

If you choose to restore a firm database over an existing one, you will overwrite data for all clients included within that database.

  1. Ensure that all users have closed Accounting CS.
  2. Launch SQL Server Management Studio by choosing Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.
  3. In the Server name field of the Connect to Server dialog, select the SQL server (for example, [SERVER_NAME]\CREATIVESOLUTION) where the databases reside, and click the Connect button.
  4. Expand the Databases folder in the Object Explorer pane.

    Note: If you are not restoring over a database, right-click the Databases folder and choose Restore Database.

  5. Right-click the ACS database (ACS_XXX_FIRM), and then choose Tasks > Restore > Database from the context menu. Show me.
    Restore database context menu
  6. In the Restore Database dialog, verify the ACS database (ACS_XXX_FIRM) is selected in the To database field.
  7. Click the From device option in the Source for Restore section and click the Ellipsis button button next to that field.
  8. In the Specify Backup dialog, click the Add button, browse to the location of the database that you want to restore, select the backup file, and click OK.

    Note: If your database backup file is not listed in the folder, select All Files(*) from the Files of type field. Valid database file extensions include .bdf or .bak.

  9. Mark the checkbox in the Restore column next to the database file to be restored. Show me.
    Select database set
  10. Select the Options page and mark the Overwrite the existing database (WITH REPLACE) checkbox. Show me.
    SQL Management Studio database restore options dialog
  11. Click OK to restore the database.
  12. When the database file has been restored successfully, click OK.

Related topics

Best practices for safeguarding your firm and client data

Backing up the firm database

Scheduling a backup of your data

Backing up and restoring data for a client via the Client Data Management Utility

Share This