How do I create a backup of my ProSystem fx Practice Management database?

  1. Log on to the Server where the SQL database resides as a Windows Administrator and browse to '\cpas\vpm' folder.
  2. Launch cpasSQLUtil.exe.
  3. At the login screen select your Practice Management SQL instance.
    • Note: This is usually servername\PRACTICEMGT.
  4. Change the Authentication to SQL Server Authentication, enter SA for the User Name, enter the appropriate password (our default is PracticeUser1), and click Logon.
  5. Right-click on your database and select Backup Database.
    • Note: The master, model, msdb, and tempdb databases are system databases and should be left alone.
  6. Browse to a location where you would like to save the backup (*.bak file) and select Save.
    • Note: The *.bak file cannot be saved across a network drive, to a device with removable storage, in any profile directory (Desktop, Documents, etc) or at the root of any drive. Please save it in a local folder first, then copy the file to an alternate location if desired.
  7. Once the backup is complete you will be returned to the main CPAS SQL Utility window. Exit the window by selecting File > Exit.

Notes:

Your SQL server\instance, database name, and server application path (CPAS folder) can be found by going to Help > About CCH ProSystem fx Practice Management and clicking on Additional Info.

Attachment:

To the left there is an attachment link to a guide on how to automate a backup routine using Microsoft® SQL Server Management Studio

  Solution Tools
  Attachments
 Solution Id sw29540
 Direct Link
Did this article answer your question or resolve your issue?

Your feedback about this article will help us make it better. Thank you!