Re: Best way to move datafile from C drive to D
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 17 Aug 2006 22:04:26 +0000 (UTC)
Stu (stuart.ainsworth@xxxxxxxxx) writes:
the safest method is to do a backup and restore; however, you can
detach, move, and reattach (usually) with no problems. Of coruse,
before doing any operation such as this, you should take a backup first
(which is why the first method is recommended).
The advantage with detach/attach is that you don't have to wait for
the new data file to be initiated. For a 3GB database that's maybe 5-10
minutes on SQL 2000. SQL 2005 has some quick initiation under some circum-
stances.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Best way to move datafile from C drive to D
- From: Mark D Powell
- Re: Best way to move datafile from C drive to D
- References:
- Best way to move datafile from C drive to D
- From: Mark D Powell
- Re: Best way to move datafile from C drive to D
- From: Stu
- Best way to move datafile from C drive to D
- Prev by Date: Re: do SS transaction logs have to be backed up for recovery to POF?
- Next by Date: Re: SQL Server 2005 Opening Script File Problem
- Previous by thread: Re: Best way to move datafile from C drive to D
- Next by thread: Re: Best way to move datafile from C drive to D
- Index(es):
Relevant Pages
|
