John W. Colby
jwcolby at colbyconsulting.com
Sat Sep 4 15:06:27 CDT 2004
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