Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 4.0 new deployment datbase file locations RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    I am planning to change the database file locations in my server from the default location to a new disc. Can I do it from Sql Management Studio using detach/attach or I have to delete the organization and then import it back? 

    The second method would take more time and that is why I want to use the first one.

     

    Tuesday, November 9, 2010 2:44 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    I think you can do it entirely in SQL Management Studio using detach then attach. Obviously you'll need to schedule downtime with your users whilst you do this.

    I don't think that CRM cares at all where the actual database files are located.

     

    Tuesday, November 9, 2010 3:18 PM
    Moderator

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    I think you can do it entirely in SQL Management Studio using detach then attach. Obviously you'll need to schedule downtime with your users whilst you do this.

    I don't think that CRM cares at all where the actual database files are located.

     

    Tuesday, November 9, 2010 3:18 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    You can change a file location without any problem unless you will not change name of DB and rights to it.

    KG

    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Tuesday, November 9, 2010 10:35 PM