[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