Moving SQL 2000 database files.

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Running out of space. How do I properly move database files (.mdf and log.ldf) to a different drive/partition on server?

-- Anonymous, January 25, 2005

Answers

Amauri,

This is well explained in the Microsoft article, "Moving SQL Server databases to a new location with Detach/Attach" at:

http://www.support.microsoft.com/?id=224071

Good Luck,

Eric

-- Anonymous, January 25, 2005


Moderation questions? read the FAQ