Hi

Can you me, I wish to achieve the following all on a single
server running SQL server 2005:

* Move everything under C:\Program Files\Microsoft SQL Server\MSSQL.
1\MSSQL\Data to D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
\Data (which will be a new folder).

* Make sure all new databases get placed in D:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\Data by default.

I realise I could use detact/attach every single database, but is
there a way to move the whole folder? I've looked for white papers/
technet articles but didn't have much joy....

Many thanks for your in advance....

You could stop your SQL Server service and move your all mdf and ndf and ldf
files to the new location, but then, records of those database would be left
in your system databases as they would not be moved formally.

I suggest you to use attach and detach to move your databases. So, when you
detach them, records of those databases would be cleared from your system
databases and there would not be junk records in your database system.

Besides, if you want to change your default database location then connect
to your SQL Serverinstance and go to its properties and then go to Database
Settings. There, you'll see Database default locations settings at the below
of the Server Properties window.

--
Ekrem Önsoy


"Alex" <postings@alexshirley.com> wrote in message
news:1192105361.573704.100610@k79g2000hse.googlegr oups.com...
> Hi
>
> Can you me, I wish to achieve the following all on a single
> server running SQL server 2005:
>
> * Move everything under C:\Program Files\Microsoft SQL Server\MSSQL.
> 1\MSSQL\Data to D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
> \Data (which will be a new folder).
>
> * Make sure all new databases get placed in D:\Program Files\Microsoft
> SQL Server\MSSQL.1\MSSQL\Data by default.
>
> I realise I could use detact/attach every single database, but is
> there a way to move the whole folder? I've looked for white papers/
> technet articles but didn't have much joy....
>
> Many thanks for your in advance....
>