SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Failover help
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rwsads
Starting Member

2 Posts

Posted - 06/06/2011 :  09:52:18  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
3328 Posts

Posted - 06/06/2011 :  10:44:42  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
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.
Go to Top of Page

rwsads
Starting Member

2 Posts

Posted - 06/06/2011 :  11:04:51  Show Profile  Reply with Quote
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.

Go to Top of Page

dinakar
Flowing Fount of Yak Knowledge

USA
2507 Posts

Posted - 06/06/2011 :  17:00:26  Show Profile  Visit dinakar's Homepage  Reply with Quote
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/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000