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 |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2010-08-05 : 07:37:46
|
| looking for a little a advice from the experts.. I have a pair of Clustered (Active Passive) SQL Servers 2005 Standard Edition (32 bit) on Service Pack 2.We are moving to a new hosting company and they have built the new cluster with SQL Server 2005 Standard Edition (64 bit) and applied Service pack 3Will I be able to restore or attach my system databases to this new system given that it is 64 bit instead of 32 and SP3 instead of sp4??? If we backed out SP3 would that make a difference? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-05 : 08:41:51
|
| I think you are fine to restore user databases from SQL 2005 SP2 database to [later version] SQL 2005 SP3 (32/64-bit is not relevant)To restore System Databases the version / service pack must be identical, and all the drives and folders will have to be identical.That's my understanding, I would suggest waiting for confirmation from someone more certain than I am! |
 |
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2010-08-05 : 08:54:12
|
| Thank you. I was afraid that I would have a problem with the diferent SP levels as far as the system DBs go.. Anyone else care to confirm? |
|
|
|
|
|
|
restoring master, msdb and model