Microsoft KB Archive/941317

= How to move Live Communications Server 2005 databases from a computer that is running SQL Server 2000 to a computer that is running SQL Server 2005 Service Pack 1 =

Article ID: 941317

Article Last Modified on 9/4/2007

-

APPLIES TO


 * Microsoft Office Live Communications Server 2005 Enterprise Edition
 * Microsoft Office Live Communications Server 2005 Standard Edition

-



INTRODUCTION
This article describes how to move the Microsoft Office Live Communications Server 2005 real-time communications (RTC) database and the RTCConfig database from a computer that is running Microsoft SQL Server 2000 to a computer that is running Microsoft SQL Server 2005 Service Pack 1 (SP1).



MORE INFORMATION
To move the RTC database and the RTCConfig database from a computer that is running SQL Server 2000 to a computer that is running SQL Server 2005 (SP1), follow these steps:  Stop the Live Communications Server service on the computer that is running Live Communications Server 2005 Enterprise Server Service Pack 1 (SP1). On the computer that is running SQL Server 2000, start SQL Server Enterprise Manager. Expand Microsoft SQL Servers, expand the server group, expand the server, and then expand Databases. Right-click the RTC database, point to All Tasks, and then click Backup Database. Right-click the RTC database, point to All Tasks, and then click Detach Database. Repeat steps 4 and 5 for the RTCConfig database. Copy the RTC database file Rtc.mdf, the RTCConfig database file Rtcconfig.mdf, and the corresponding .ldf file to the computer that is running SQL Server 2005 SP1.

Note The files are in the &quot;Live Communications Server 2005 data&quot; folder.</li> On the computer that is running SQL Server 2005 SP1, start SQL Server Management Studio.</li> Expand the server, right-click Databases, and then click Attach.</li> On the Attach Databases page, click Add, click the Rtc.mdf file, and then click OK.</li> Repeat step 10 for the Rtcconfig.mdf file.</li> For the RTC database and for the RTCConfig database, determine whether you have permit permissions for the following groups:

RTCDOMAINSERVICES, RTCHSDOMAINSERVICES, RTCABSDOMAINSERVICES, ENTERPRISEADMIN

</li> For the RTC database and for the RTCConfig database, examine the logon to determine whether RTCDOMAINSERVICES, RTCHSDOMAINSERVICES, RTCABSDOMAINSERVICES, BUILTIN Administrators, and SA are displayed.</li> Click Start, click Run, type compmgmt.msc, and then click OK. Make sure that the RTCDOMAINSERVICES group and the ENTERPRISEADMIN group are part of the local administrator group.</li> Make sure that the server that is running SQL Server 2005 SP1 uses both Windows authentication and SQL Server authentication.</li> On the computer that is running Live Communications Server 2005, run the following command: LcsCmd.exe /forest /action:UpdatePoolBackend /poolname: /poolbe: \

Note In this command,  is a placeholder for the old pool name. is a placeholder for the computer that is running SQL Server 2005 SP1. is a placeholder for the instance name of SQL Server 2005 SP1.</li></ol>

Keywords: kbexpertiseinter kbhowto KB941317

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.