locked
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

Answers

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

    http://msdn.microsoft.com/en-us/library/ms189133(v=SQL.100).aspx

    How to Move a Database Using Detach and Attach

    http://msdn.microsoft.com/en-us/library/ms187858(v=SQL.100).aspx

    HTH

     


    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