HELP!!! Need to move database from one drive to another on the same server
Posted on 2011-03-15
Hi, I am new to sql server arena, but I have been tasked to setup SQL Server 2005 x64 SP4 on a Server 2008 R2 box, which I have. I thought I was installing the SQL Server on the D: drive, but apparently not. So, when I made the databases for some reason they are in the default location on the C: drive (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data). I would rather have them on the D: drive which has several terabytes of space. (D:\SQLServer\Data).
Also, there are a couple of databases on the D: drive that I would like to move into this D:\SQLServer\Data folder.
What is the process of accomplishing these tasks?
Thanks in advance.