October 21, 2002 at 1:21 pm
On way to copy a Sql 7 installation (say in d:\mssql7\) to another server is to install Sql 7 on the other server (in d:\mssql7), stop the service, and then copy the files from the original sever "Data" directory to the new one.
How does the "attach\re-attach" approach compare in this setting?
TIA,
Bill
October 21, 2002 at 1:47 pm
Attach/detach really just adds/removes a row from sysdatabases. Beyond that to copy the mdf without detaching you have to stop the service on both machines. Both are valid techniques and have their place.
Andy
October 21, 2002 at 3:38 pm
sp_attach and sp_detach are the supported mechanisms for doing this.
You can't detach master.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply