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 a local SQL database to a remote SQL server database from OfficeScan (OSCE) 11.0

    • Updated:
    • 5 Mar 2018
    • Product/Version:
    • OfficeScan 11.0
    • OfficeScan 11.0
    • OfficeScan XG
    • OfficeScan XG.All
    • Platform:
    • Windows 2003 Datacenter 64-bit
    • Windows 2003 Enterprise
    • Windows 2003 Server R2
    • Windows 2003 Standard 64-bit
    • Windows 2008 Datacenter
    • Windows 2008 Datacenter 64-bit
    • Windows 2008 Enterprise
    • Windows 2008 Enterprise 64-bit
    • Windows 2008 Server R2 Enterprise
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2008 Web Server Edition
    • Windows 2008 Web Server Edition 64-bit
    • Windows 2012 Datacenter R2
    • Windows 2012 Enterprise
    • Windows 2012 Enterprise R2
    • Windows 2012 Server Essential R2
    • Windows 2012 Server Essentials
    • Windows 2012 Standard
    • Windows 2012 Standard R2
Summary

You want to transfer OSCE’s local SQL database to an SQL server on a remote machine.

Details
Public

To move the SQL database:

  1. Turn off Firewall.
  2. Turn on Network Discovery on both the local OSCE server machine and the target SQL machine. Make sure that the machines are connected.
  3. Use SQL Management Studio to back up the local OSCE SQL database to a backup file:
    1. Go to Options.
    2. Select “Backup to a new media set”.
  4. Go to the target remote SQL server.
  5. Restore the backup file generated in Step 3 to a new database and set the file name. The database should now be on the remote SQL server.
  6. Go to the local OSCE server.
  7. Open the SQL transfer tool, SQLTXFR.EXE.
  8. Select the “Switch to an existing OfficeScan SQL database” option.
  9. Confirm the authentication of the remote SQL server.
  10. Set the database name to match the restored database name in the target remote SQL server.
  11. Click OK. The SQL should be transferred successfully.

If you encounter an issue when switching the database, please contact Trend Micro Technical Support.

Premium
Internal
Partner
Rating:
Category:
Migrate
Solution Id:
1112753
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