Express SQL Server 2008, attach & detach RRS feed

  • Question

  • how do I move a 2008 SQl Express DB without code?

    Stop the service then move the db then restart???





    • Edited by RockinRon399 Saturday, October 2, 2010 12:54 AM edit question
    Saturday, October 2, 2010 12:53 AM


All replies

  • Hi Ron,

    Not sure what exactly you means.

    It seems you want to move your USER databses from QL 2008 Express Edition to somewhere else. If yes then you can Use Attach Dettach method or as you mentioned will stop sql services and then move database files to new location.

    Moving Database Files


    How to Move a Database Using Detach and Attach




    Regards Gursethi Blog: http://ms-gursethi.blogspot.com/ ++++++++++++++++++++++++++++++++++++ Please mark "Propose As Answer" if my answer helped +++++++++++++++++++
    • Marked as answer by RockinRon399 Sunday, October 3, 2010 10:05 AM
    Saturday, October 2, 2010 9:04 AM
  • What do you mean by without code ..
    Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/
    Saturday, October 2, 2010 2:02 PM
  • I was not sure if code was required to move a db.



    Sunday, October 3, 2010 10:06 AM