DB Precision has the ability to support up to 4 databases instances (including the production server). Having multiple instances can be useful for setting up a test server (for testing new plan coding) or a disaster recovery server. Once multiple instances are created, users can login in to each server as well as transfer information between servers.

To enable multiple database servers within DB Precision, you must first complete the following steps (requires full SQL Server database access):

1. Database Backup: In SQL Management Studio, backup the following two databases from the production server: 1) PSArchive, and 2) PSPrecision, each to their own backup file (PSPrecision.bak, and PSArchive.bak for example).
2. Database Creation: In SQL Management Studio on the new server (or instance on an existing server), create the two databases PSPrecision and PSArchive by right-clicking Databases and selecting New Database....
3. Database Restore: Right-click each newly created database (under the Databases branch) and select Tasks - Restore - Database... from the resulting menu. Under Source, select the Device option and then navigate to the backup file for each database (created in Step 1). On the Options page, check the box Overwrite the existing database (WITH REPLACE). No other boxes on this page should be checked. Then press OK to restore the database.
4. Remove PSUser from Two Databases:  Under each database, select Security - Users, right-click PSUser, and then select Delete to remove the SQL user PSUser (created under the prior server) from each database.
5. Create SQL Login on New Server: Create a new SQL Login by expanding the Security item in Object Explorer of Management Studio and right-clicking Logins. Select New Login... from the resulting menu and then provide the name PSUser for login name. Select SQL Server authentication and uncheck Enforce password policy. Under User Mapping, check the Map box for PSPrecision and PSArchive. Make sure that db_owner and public are checked for each database under Database role membership. Choose a password that is the same password as was used on the production server.
6. DB Precision Configuration: Log in to DB Precision as a System Administrator, and open the System Settings screen (System - System Settings). On the General tab, select from the one of the three non-production choices (Test, Backup, or Remote), the name of the server (including instance name).
7. User Configuration: Open up the DB Precision System Users and/or User Groups and under Standard Rights, select which users are to have access to the multiple servers (using the Multiple Servers options of None or Edit).

Once this has been done, Users with access rights will be able to connect to different databases on login, change databases using the Change button in the DB Precision caption bar (must be displayed, see System - Caption Bar), as well as transfer information between servers (Data - Transfer Server Data).