Express SQL Server 2008, attach & detach

Question

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

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

 

 

 

 

Answer 1

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 +++++++++++++++++++

Answer 2

What do you mean by without code ..

---

Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/

Answer 3

I was not sure if code was required to move a db.