Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

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
Move or migrate the database used by the PolicyServer to a new SQL server using .mdf and .ldf files when the PolicyServer server machine is unchanged.
To migrate the PolicyServer database:
  1. Stop the PolicyServer Windows Service.
  2. Back up the MobileArmorDB and MobileArmorLog databases. Detach them afterwards.
  3. 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
  4. On the new SQL server, attach both databases using the MDF and LDF files.
  5. 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
  6. 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.
  7. Log in to the PolicyServer using the PolicyServer MMC.
    Note: The server name should be the PolicyServer machine and not the SQL server.
Configure; Troubleshoot; Deploy; Upgrade; Migrate
Solution Id:
Did this article help you?

Thank you for your feedback!

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.