Migrate PolicyServer database using the .mdf and .ldf files

Migrating PolicyServer database to a new SQL server using the .mdf and .ldf files

- Updated:
- 7 Nov 2019
- Product/Version:
- Endpoint Encryption
- Platform:
- Windows 2003 Enterprise
- Windows 2003 Enterprise 64-bit
- Windows 2003 Standard
- Windows 2003 Standard 64-bit
- Windows 2008 Enterprise
- Windows 2008 Enterprise 64-bit
- Windows 2008 Server R2
- Windows 2008 Standard
- Windows 2008 Standard 64-bit
- Windows 8 32-bit
- Windows 8 64-bit
- Windows Vista 32-bit
- Windows Vista 64-bit
- Windows XP SP3 32-bit

To migrate the PolicyServer database:

Stop the PolicyServer Windows Service.
Back up the MobileArmorDB and MobileArmorLog databases. Detach them afterwards.
Copy the following MDF and LDF files for both databases and move them to the new SQL server:
- MobileArmorDB.mdf
- MobileArmor_log.ldf
- MobileArmorLog.mdf
- MobileArmorLog_log.ldf
On the new SQL server, attach both databases using the MDF and LDF files.
Recreate the SQL Login account and associate it to the existing SQL database users by running SQL queries on both databases by doing the following:
1. Right-click database and select New Query.
2. Run the following queries:
  
  sp_change_users_login cannot be used to map database users to Windows-level principals, certificates, or asymmetric keys. To add orphaned users, check this Microsoft article.
  - "sp_change_users_login 'Report'"
    This lists the PolicyServer database username if unknown.
  - "sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'"
    This creates and sets a password for the new Login, and then link it to the existing database user.
    
    Take note of the Login name and password as they will be used later for the PolicyServer application server installation.
    - ‘user’ is the PolicyServer database username (used for original installation or found via sp_change_users_login ‘Report’)
    - ‘login’ is the desired SQL login name
    - ‘password’ is the desired password for the SQL login
Do any of the following:
- Reinstall the PolicyServer.
  1. On the PolicyServer machine, run the PolicyServer installer and select Restore.
  2. When prompted to enter a SQL database, enter the server and credentials of the new SQL server.
  3. Proceed with the installation until it completes.
- Use the PolicyServer Change Setting Tool to point your existing PolicyServer to the new SQL Server.
Log in to the PolicyServer using the PolicyServer MMC.
Note: The server name should be the PolicyServer machine and not the SQL server.

Need More Help?

Migrating PolicyServer database to a new SQL server using the .mdf and .ldf files