Move System Databases 1

[jxc]

I have a requirement to move my SQL server databases from 1 volume to another. I can move user databases without a problem by simply using backup and restore. I am not sure however what is the best way to move the system databases which are created on install. Once moved I need to give up my old volume to another application.

Any thoughts would be greatly appreciated.

/jxc

 

[tlbroadbent]

The article at the following link provides all the info needed to move databases to a new location.

INF: Moving SQL Server Databases to a New Location with Detach/Attach

http://support.microsoft.com/default.aspx?kbid=224071

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[jxc]

Exactly what I was looking for....Many thanks.