Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
crm database disk partition move RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi there,

     

    I need to move my CRM DB from C://  partition to my  D:// partition (c:// will explote soon) i want  to ask if these are the steps i should take for this:

     

    1- Backup the dabatabase

    2- Move the database from c :// to d:// using standar procedure with sql server managment studio(ie. deatach the DB, then move .dbf and .ldf files to d:// , finally reatach the DB from the new location)

    3- Ready to go

     

    Should i do something special with the CRM? like turn off the iss, make any trick with the "deployment manager" or something?

     

    Cheers

    Thursday, October 7, 2010 6:14 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello.

    I have done this procedure several times so I definitely can help you.

    1. Stop your CRM website.

    2. Stop Microsoft Asynchronous Service.

    3. Open SQL Management studio, click with the right of mouse on DB and choose detach DataBase.

    4. Copy MDF and Log files to other partition.

    5. In SQL Management Studio click with right of mouse on databases and choose Attach.

    6. In appeared dialogue choose MDF and Log files, and click ok.

    7. Run Microsoft Asynchronous Service.

    8. Run your CRM WebSite.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Thursday, October 7, 2010 7:30 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    hi there,

    By the way,  i need to pass al the data from the producion DB to my development DB, any suggetsions about how can this be done easily?

     

    Cheers


    In this case you can try to use following approach (I don't know will it work for you).

    1. Make backup of your test DB.

    2. Restore it on production server.

    3. Using deployment manager attach it to existing deployment through import organization wizard.

     

    If this approach would not work for your case the easiest way is to backup your test DB, restore on the same SQL server where production runs and using direct SQL queries - move data from one DB to other.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Thursday, October 7, 2010 8:41 PM
    Moderator

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    You can check this:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;952934&sd=rss&spid=12976

    It has the procedure for SQL 2005 but it works for SQL 2008 as well.

    Regards,

    Amol

    Thursday, October 7, 2010 6:41 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello.

    I have done this procedure several times so I definitely can help you.

    1. Stop your CRM website.

    2. Stop Microsoft Asynchronous Service.

    3. Open SQL Management studio, click with the right of mouse on DB and choose detach DataBase.

    4. Copy MDF and Log files to other partition.

    5. In SQL Management Studio click with right of mouse on databases and choose Attach.

    6. In appeared dialogue choose MDF and Log files, and click ok.

    7. Run Microsoft Asynchronous Service.

    8. Run your CRM WebSite.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Thursday, October 7, 2010 7:30 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    yay! thanks
    Thursday, October 7, 2010 8:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    hi there,

    By the way,  i need to pass al the data from the producion DB to my development DB, any suggetsions about how can this be done easily? or can i make the CRM point another DB?

     

    Cheers

    Thursday, October 7, 2010 8:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    hi there,

    By the way,  i need to pass al the data from the producion DB to my development DB, any suggetsions about how can this be done easily?

     

    Cheers


    In this case you can try to use following approach (I don't know will it work for you).

    1. Make backup of your test DB.

    2. Restore it on production server.

    3. Using deployment manager attach it to existing deployment through import organization wizard.

     

    If this approach would not work for your case the easiest way is to backup your test DB, restore on the same SQL server where production runs and using direct SQL queries - move data from one DB to other.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Thursday, October 7, 2010 8:41 PM
    Moderator