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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 21:42:41
|
Ben writes "We have SQL Server 2000 on Win2k Server (SP1) located in a data center. The SQL server is used by several client's websites (located on separate servers), so it has active connections all the time. We need to move the SQL server to another data center with as little interruption to production as possible. What is the best and most efficient way to do this. We are considering building a new server matching the current SQL box, then Detaching the databases and copying them over. What do you suggest?
thanks,
Ben
---------------------------------------
The Best Support On The 'Net
Windows 2000 Advanced Hosting
http://www.orcsweb.com/
---------------------------------------" |
|
|
|
|
|
Moving SQL 2000 production server