Francisco Tapia
fhtapia at gmail.com
Sat Sep 4 23:22:22 CDT 2004
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. > > John W. Colby > www.ColbyConsulting.com > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com -- -Francisco