Restore a database backup
Because Practice CS uses a Microsoft SQL database, there are special considerations when restoring a backup of a database. The following procedure outlines how to restore a database through Practice CS.
Practice CS databases can also be restored outside the application using Microsoft SQL Server Management Studio.
note
If you're running Practice CS through Virtual Office CS or SaaS, the
Restore
command isn't available. To restore your data, contact Support. The process can take up to 24 business hours.To restore a Practice CS database, follow these steps.
- Copy the backup file to any location on your database server.note
- To restore a SQL database, the backup file needs to reside on the database server.
- After you make a backup, you may need to place the .BDF file within your SQL data structure (not in the root of C: on the server) before you try to restore it. The default path isC:/Program Files (x86)/Microsoft SQL Server/MSSQL_10_50.xxx/MSSQL/Data.
- SelectFile, thenRestore.
- In the Backup file\directory field, enter the path, and optionally, the file name, of the database backup, or select
and go to the file. note- Backup files have a file extension of BDF or BAK.
- You need to save the backup file on the drive where SQL is installed.
- Enter a new name for the database in theNew Firm namefield.note
- It's necessary to enter a new name for the database, because the application doesn’t replace existing databases and doesn’t let 2 firm databases have the same name.
- If you do want to restore a database using the same name as an existing database, you must first open the existing database, delete it (File, thenDelete Firm), open another database (such as Sample), selectFile, thenRestore, and select the database you want to restore.
- From the list at the bottom of the Restore window, select the database to restore.
- SelectOK.
- At the confirmation that the database has been restored, selectOK.
