Trend Micro - Securing Your Journey to the Cloud Business
Support
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:
    • 1 Apr 2014
    • Product/Version:
    • Endpoint Encryption 3.1 PolicyServer
    • Endpoint Encryption 5.0
    • 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
Summary
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.
Details
Public
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 '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. 
        • ‘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
        Note: Take note the Login name and password as they will be used later for the PolicyServer application server installation.
  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.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Deploy; Upgrade; Migrate
Solution Id:
1060812
Feedback
Did this article help you?

Thank you for your feedback!

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.

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.
Related Articles