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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-01-24 : 13:02:56
|
| Hi Tara,I am rebuilding standalone sql server 2005 standard edition on windows 2003 sp3. Previously it was active/passive cluster. We have backup on netbackup. So after sql server 2005 standard edition installation I want to install SP3. Previously it was SP2 on cluster. Is there will be any issue with restoration of system and user databases or any thing else if I change SP from SP2 to SP3 on new server?Thanks |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-24 : 15:55:01
|
| There will be a problem restoring the system databases if you restore them after upgrading. Since you are rebuilding the system, I wouldn't bother with restoring the system databases at all.I would script out the logins, jobs and any other objects stored in the system databases and rebuild those on the new system. Then, restore the user databases.Jeff |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-01-24 : 16:01:30
|
| Thanks for reply. |
|
|
|
|
|
|
SP3