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 |
|
rwsads
Starting Member
2 Posts |
 Posted - 2011-06-06 : 09:52:18
|
| I have a SQL 2005 server with the latest sp on a Windows 2008 server 32-bit.I have a new server that is windows 2008 64-bit that I want to be a backup incase my current server fails. Can I just install my SQL 2005 32-bit with latest sp on the new machine and allow the system to work?It will only be a temp solution if there is a problem. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-06 : 10:44:42
|
| How are you planning to swap over to the new machine?Note: this is often more about planning, documentation and testing than the technological parts.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rwsads
Starting Member
2 Posts |
Posted - 2011-06-06 : 11:04:51
|
| Currently the 2nd/failover machine is my disk backup for netbackup.I plan on just restoring the database to the 2nd/Failover machine and using the SQL 2005 to bring it up and make it run.It would only be a temp solution in case something real bad happens to production. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-06-06 : 17:00:26
|
| if you want to back up from your primary server and restore on the secondary server then the 32bit vs 64 bit doesnt matter. If you are thinking about including the 64bit server as a new node in the cluster then its not possible. All nodes have to have same version of the OS and SQL Server and similar hardware (it has to pass the Cluster Validation test).Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Failover help