none
OCS R2 move archiving database

    Question

  • Hi all,
    I need to migrate the archiving back end database from one sql server to an other sql server, which is the best practice for do that? Also i need to keep the data in the db.
    Thank all for your reply
    Ricardo
    Ricardo Ernst unifiednow@gmail.com
    Wednesday, March 10, 2010 9:40 AM

Answers

  • Here is the article about "How to Move OCS Enterprise SQL Database to another Server ",
    http://blogs.technet.com/dodeitte/archive/2009/06/05/how-to-move-ocs-enterprise-sql-database-to-another-server.aspx

    You may refer to the part of backup and restore the SQL data,then finished below steps:
    1. Activate the Archiving Server.

      LCSCmd.exe /Archiving /Action:Activate /backend:<SQL instance name (computer\instance name)> /dbname:<database name> /DBDataPath:<DB data file path> /DBLogPath:<DB log file path> [/Password:<Account Password>] [/RefDomain:<Domain FQDN>] [/PDCRequired[:{TRUE|FALSE}]] [/GlobalSettingsDC:<FQDN of a global settings domain controller>] [/DC:<domain controller FQDN>] [/GC:<Global Catalog FQDN>] [/Global:{Configuration | System}] [/User:<Account Name>] [/NoStart[:{TRUE|FALSE}]] [/clean[:{TRUE|FALSE}]] [/L:<log file path>][/XML[:{TRUE|FALSE}]] [/?[:{TRUE|FALSE}]]

      Here is the same command with sample data.

      LCSCmd.exe /Archiving /Action:Activate /Password:p@ssw0rd /backend:ArchivingServer\Live /dbname:Archive /DBDataPath:"e:\Microsoft\LC Data" /DBLogPath:"e:\Microsoft\LC Archiving Log"

    2. Start the Archiving Server service.

      net start RTCLOG  

      Resource:
      http://technet.microsoft.com/en-us/library/dd572313(office.13).aspx


    Best Regards!
    • Proposed as answer by Ben-Shun Zhu Thursday, March 11, 2010 8:31 AM
    • Marked as answer by Ricardo Ernst Thursday, March 11, 2010 9:21 AM
    Thursday, March 11, 2010 8:29 AM
  • "How to move the archiving database in Communications Server"
    http://support.microsoft.com/kb/961950

    Best Regards!
    • Proposed as answer by Ben-Shun Zhu Thursday, March 11, 2010 8:31 AM
    • Marked as answer by Ricardo Ernst Thursday, March 11, 2010 9:21 AM
    Thursday, March 11, 2010 8:31 AM

All replies

  • Here is the article about "How to Move OCS Enterprise SQL Database to another Server ",
    http://blogs.technet.com/dodeitte/archive/2009/06/05/how-to-move-ocs-enterprise-sql-database-to-another-server.aspx

    You may refer to the part of backup and restore the SQL data,then finished below steps:
    1. Activate the Archiving Server.

      LCSCmd.exe /Archiving /Action:Activate /backend:<SQL instance name (computer\instance name)> /dbname:<database name> /DBDataPath:<DB data file path> /DBLogPath:<DB log file path> [/Password:<Account Password>] [/RefDomain:<Domain FQDN>] [/PDCRequired[:{TRUE|FALSE}]] [/GlobalSettingsDC:<FQDN of a global settings domain controller>] [/DC:<domain controller FQDN>] [/GC:<Global Catalog FQDN>] [/Global:{Configuration | System}] [/User:<Account Name>] [/NoStart[:{TRUE|FALSE}]] [/clean[:{TRUE|FALSE}]] [/L:<log file path>][/XML[:{TRUE|FALSE}]] [/?[:{TRUE|FALSE}]]

      Here is the same command with sample data.

      LCSCmd.exe /Archiving /Action:Activate /Password:p@ssw0rd /backend:ArchivingServer\Live /dbname:Archive /DBDataPath:"e:\Microsoft\LC Data" /DBLogPath:"e:\Microsoft\LC Archiving Log"

    2. Start the Archiving Server service.

      net start RTCLOG  

      Resource:
      http://technet.microsoft.com/en-us/library/dd572313(office.13).aspx


    Best Regards!
    • Proposed as answer by Ben-Shun Zhu Thursday, March 11, 2010 8:31 AM
    • Marked as answer by Ricardo Ernst Thursday, March 11, 2010 9:21 AM
    Thursday, March 11, 2010 8:29 AM
  • "How to move the archiving database in Communications Server"
    http://support.microsoft.com/kb/961950

    Best Regards!
    • Proposed as answer by Ben-Shun Zhu Thursday, March 11, 2010 8:31 AM
    • Marked as answer by Ricardo Ernst Thursday, March 11, 2010 9:21 AM
    Thursday, March 11, 2010 8:31 AM
  • Thanks guys for the answer, is what i looking for.
    Best Regards


    Ricardo Ernst ricardoernst.wordpress.com unifiednow@gmail.com
    Thursday, March 11, 2010 9:22 AM