Mirror Server

i am looking at options for a 'hot spare' server for my SQL application
the ideal senario would be that the 2nd server would 'take over' under a
controlled manner as the same server etc
anybody using any third party solutions that can handle this?
Many thanks
Jez
jez_UK,
Do you want to protect your disks as well as the server hardware? Have a
look at clustering. How far apart physically are your servers? Also look
out for database mirroring in SQL Server 2005 next year - this has an
automatic three second failover time.
When you say "controlled manner" do you mean manually? How much data
loss can you tolerate? You might also want to consider log shipping and
possibly a third party replication tool like Double-Take from NSI software.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
jez_UK wrote:
> i am looking at options for a 'hot spare' server for my SQL application
> the ideal senario would be that the 2nd server would 'take over' under a
> controlled manner as the same server etc
> anybody using any third party solutions that can handle this?
>