Tuesday, March 15, 2011

How to manage local sql server database files?

My system is for development, and I run a local copy of sql server 2005. I want to move all the database files out of program files, and put in a better location on another partition. To do this would you simply detach all the databases in SSMS, move the .mdf and .ldf files with windows explorer, then reattach?

From stackoverflow

0 comments:

Post a Comment