[dba-SQLServer] Fwd: Move database files from disk to disk

---------- Forwarded message ----------
From: Tom Cooper <tomcooper at comcast.net>
Date: Sun, 5 Sep 2004 10:01:49 -0400
Subject: RE: Move database files from disk to disk
To: SQL Server 2k List <sql2k at ls.sswug.org>

KB article 224071

http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

explains how to move any database, both user and system dbs.

Tom

> -----Original Message-----
> From: bounce-sql2k-6393174 at ls.sswug.org [mailto:bounce-sql2k-
> 6393174 at ls.sswug.org] On Behalf Of Francisco Tapia
> Sent: Sunday, September 05, 2004 12:22 AM
> To: SQL Server 2k List
> Subject: Move database files from disk to disk
>
> I don't see where else to do that unless you do it upfront in the
> installation, I'm going to CC: another really good list on this and
> find out if anyone has any ideas (i'll reply to you if anything comes
> back.
>
>
> ---------- Forwarded message ----------
> From: John W. Colby <jwcolby at colbyconsulting.com>
> Date: Sat, 04 Sep 2004 16:06:27 -0400
> Subject: RE: [dba-SQLServer] Move database files from disk to disk
> To: dba-sqlserver at databaseadvisors.com
>
> No, I mean the entire shootin match.  I "set up" sql server and failed to
> specify where I wanted the data files.  I need to move everything, the
> system database etc.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
> Tapia
> Sent: Saturday, September 04, 2004 3:54 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Move database files from disk to disk
>
> just modify your paths accordingly
>
> EXEC sp_attach_db @dbname = N'MyDB',
>   @filename1 = N'd:\SqlServer\data\MyDB.mdf',
>   @filename2 = N'f:\FastLogDisk\MyDB_log.ldf'
>
> On Sat, 04 Sep 2004 14:02:26 -0400, John W. Colby
> <jwcolby at colbyconsulting.com> wrote:
> > I need to move a database from one disk to another, and can't remember
> > how. I have disconnected my main (user) database and now need to move
> > all the system stuff.
> >
-------------
See http://www.sswug.org/archives for list archives.
mailto:listadmin at sswug.org with list issues.





-- 
-Francisco