Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Move the data and Log files

Author  Topic 

learntsql

524 Posts

Posted - 2009-11-18 : 23:39:09
Hi....
I have default installation path for my mdf and ldf files and that drive has become full.
Now I have to move those mdf and ldf files to another drive.
These(3 databases) are production databases.
How to move those files to another drive without any down time.
Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-18 : 23:47:49
This will require downtime, no matter which method you pick.

Here's the easiest method: http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -