Move C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to D Drive
- From: Alex <postings@xxxxxxxxxxxxxxx>
- Date: Thu, 11 Oct 2007 05:22:41 -0700
Hi
Can you help 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 help in advance....
.
- Follow-Ups:
- Prev by Date: Re: Error 18025: xp_test_mapi_profile : failed with mail error 0x80040
- Next by Date: Re: Move C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to D Drive
- Previous by thread: optimistic locking
- Next by thread: Re: Move C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to D Drive
- Index(es):
Relevant Pages
|
