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 |
|
Minesalatte
Starting Member
10 Posts |
 Posted - 2008-12-05 : 07:43:35
|
| Hi,I have an SQL 2005 server with around 50 Databases and 100 users. Naively I used RAID 5 and installed it on Windows 2003 Standard (32 bit) so I'm suffering poor I/O and running low on limited RAM. I have purchased a new server configured RAID 10 and installed Windows Enterprise. Now I'm looking to perform a root and branch migration of the SQL instance to the new server. I would like the new server be a replica of the original so I can plug and play.What is the best method to achieve this?Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 09:10:11
|
| Backup/Restore or Attach /Detach. There are millions of post regarding this case .Please search it in SQLteam. |
 |
|
|
Minesalatte
Starting Member
10 Posts |
Posted - 2008-12-05 : 10:18:30
|
| Thanks sodeep, I know how to Attach/Detach & Backup/Restore databases, though I'm not sure how to backup/restore users/logins, I can find that out.I was looking more at migrating the whole instance, probably just looking for something clever, maybe over thinking it a little. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 10:21:14
|
| Here is one:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110473 |
|
|
|
Minesalatte
Starting Member
10 Posts |
Posted - 2008-12-05 : 11:07:28
|
| That looks spot on, thanks for your help. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 11:10:13
|
Cool.  |
|
|
|
|
|
|
Migrate SQL instance to separate physical server