We help IT Professionals succeed at work.

Warm Standby Server

crishna1
crishna1 asked
on
382 Views
Last Modified: 2012-05-06
Experts,
I have a SQL 2005 database server which has about 20 user databases which  total upto 1 TB.We have nightly backups and they go onto the tape eventually everyday.
In case this server crashes what are my options beside restoring from the backups.
someone mentioned Warm Standby Server, is it a feasible solution? pros and cons? basically we want to reduce the down time.

please suggest
regards

Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
you can maintain warm stand by server with Log Shipping, which is not a bad idea. have a look at below URL

http://www.aldex.co.uk/continuity.html

https://www.experts-exchange.com/Database/Sybase/Q_23979216.html
CERTIFIED EXPERT
Awarded 2008
Awarded 2008
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for the updates.

I have a sql server 2005 database server, machine A(primary dbserver), with 20 databases on it. I have hardware available for another SQL Server 2005. What do i do from here?  
1) intall SQL Server 2005 on machine B (which would be standby server)
 and then what are the steps to do..? i am guessing
2) backup the 20 databases  from Server A
3) restore them on Server B

4) how do i transport the transaction log from server A to B?
Can this be automated, if so how? can i set it to happen every hour?
 or what  is the optimal way of doing it?

regards...
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
Log shipping is an automated process....follow this wizard.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1309728,00.html

Author

Commented:
it has been decided to go with clustering, can you point me with some good notes for SQL Server 2005 clustering? is there a sstep by step setup?
CERTIFIED EXPERT
Awarded 2008
Awarded 2008
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
i guess so. Thanks for the updates. i just created a second instance on sql server 2005 and having issue connection. i verified that the "allow remote connections" is checked . i believe something is wrong with the TCP/IP port. i played with SQL Configuration Manager and messed it up. how do i fix it? the first instance is working fine and it is listening on port 1433. The error log for the named isntance is showing , port 3000 and 3831, what do i have to do?
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
new question....this is nothing related to your current question.  please close this question out and submit a new one.
yeah, me either aggree with Chapman.
as about original question of Warm Standby server, we have given answer in first three post itself.

Author

Commented:
chapmandew, you mentioned clustering involves quite a bit of money, approx how much u think?
well it needs some special server and special kind of expertise, it depends on what servers and expert you choose
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
it will require specialized hardware, and maintenance....you're probably talking several hundred thousand to do it correctly and robustly.

Author

Commented:
even just for failover clustering? Active/Passive?
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
Yep...the licenses aren't whats going to cost you the most in active/passive...its the hardware that you have to pay for that will basically be sitting idle when you're on one node.  Its not a cheap solution...a good one, YES...a cheap one to do right, no.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.