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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2002-04-07 : 01:00:56
|
| Ok, we're about to do an upgrade on our SQL server hardware. In theory it will be painless, as the DB and logs live on a RAID array that is totally seperate from the OS.I'm planning on having the new unit all ready to go, swapping the raid controller into it, and attaching the DB / log files. What I'd like to do is to set up the new machine with SP2.. however, the production unit is running SP1.Now, I know I could do SP2 to the current production unit just before taking it OOS, or I could set up the new unit with SP1, then attach the DB, then do SP2.However, to minimize downtime, I'd like to just attach the DB to the new server.Has anyone done this? Should a SP affect anything in an actual database, or just MSDB, Master, etc?Thanks-b |
|
|
Nazim
A custom title
1408 Posts |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-04-08 : 05:35:09
|
| We have done exactly this with SQL7 with no problems at all. |
 |
|
|
|
|
|
|
|
Detach/Attach, SP1 -> SP2 OK?