Microsoft KB Archive/937876

= How to use Microsoft SQL Server Management Studio Express to move the Microsoft Dynamics CRM laptop client for Outlook database to a different location =

Article ID: 937876

Article Last Modified on 8/21/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0
 * Microsoft CRM client for Microsoft Office Outlook, when used with:
 * Microsoft Dynamics CRM 3.0

-



INTRODUCTION
This article describes how to use Microsoft SQL Server Management Studio Express (SSMSE) to move the Microsoft Dynamics CRM laptop client for Microsoft Office Outlook database to a different location.



MORE INFORMATION
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

To use SSMSE to move the database to a different location, follow these steps:  Back up the Microsoft Dynamics CRM laptop client for Outlook database that you want to move. Log on to the Microsoft Dynamics CRM laptop client for Outlook, click Go Online, and then synchronize all the offline data to the Microsoft Dynamics CRM 3.0 server. Exit the Microsoft Dynamics CRM 3.0 laptop client for Outlook. Start SSMSE.

Note For more information about how to obtain SSMSE and how to install SSMSE, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

 Connect to the local instance of the Microsoft Dynamics CRM 3.0 laptop client for Outlook. Expand Databases. Right-click the Metabase database.</li> Point to Tasks, and then click Detach.</li> Click OK.

Note If you receive a message that states that some users are connected to the Microsoft Dynamics CRM laptop client for Outlook database, click Drop connection.</li> Right-click the MSCRM_MSDE database.</li> Repeat step 8 through step 9.</li> Move the Metabase database files to the folder where you want to store the Metabase database.</li> Move the MSCRM_MSDE database files to the folder where you want to store the MSCRM_MSDE database.</li> In SSMSE, right-click Databases, and then click Attach.</li> In the Attach databases dialog box, click Add.</li> Select the folder to which you moved the Metabase database files, and then click OK.</li> In the Attach databases dialog box, click Add.</li> Select the folder to which you moved the MSCRM_MSDE database files, and then click OK.</li></ol>

Keywords: kbcrmv3c kbmbsinstallation kbmbsadministration kbexpertisebeginner kbmbsmigrate kbhowto kbexpertiseinter KB937876

-

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

© Microsoft Corporation. All rights reserved.