Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2004-09-17 : 12:58:31
|
| Env.: Win2000, SQL2000I need to creat a server exactly like what we have in production. I took these steps:1. Stopped SQL-Server in production. Of course when it was not in use :)2. Coppied the E:\MSSQL\DATA folder to new server. This is where I have all DBs including Master, MSDB, Model. (SQL Server is installed on C: drive)3. Start SQL-Server.As a next step, should I attach the databases to SQL-Server on new server? And replace the Master, MSDB, and Model databases with existing ones on New server?Am I on right path? Or there is a better way? ThanksCanada DBA |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-09-17 : 13:03:46
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;224071-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Copy SQL to New server