MS SQL Server - How to move database files with no downtime?

Author

How to move database files with no downtime?

Olav Tollefsen

2006-10-31, 12:15 am

How can I move my SQL Server 2005 database files from one volume (disk) to
another without taking the database offline?

Olav

Arnie Rowland

2006-10-31, 12:15 am

The short answer is: You can't.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

"Olav Tollefsen" <x@y.com> wrote in message
news:OsmVF72%23GHA.3952@TK2MSFTNGP03.phx.gbl...
> How can I move my SQL Server 2005 database files from one volume (disk) to
> another without taking the database offline?
>
> Olav

Theo Verweij

2006-10-31, 12:15 am

Correct, see http://msdn2.microsoft.com/en-us/library/ms345483.aspx

Arnie Rowland wrote:
> The short answer is: You can't.
>

Tibor Karaszi

2006-10-31, 12:15 am

I guess one could create a new file on the other disk, and then DBCC SHRINKFILE with the EMPTYFILE
option for the file no longer required. After that remove the old file. It will be a time-consuming
operation and will not work for mdf files.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Theo Verweij" <tverweij@xs4all.nl> wrote in message news:uigR3j3%23GHA.1196@TK2MSFTNGP02.phx.gbl...[color=darkred]
> Correct, see http://msdn2.microsoft.com/en-us/library/ms345483.aspx
>
> Arnie Rowland wrote:

Sponsored Links