Best way to implement "warm" standby? - considering log shipping

Hi Larry,
Log Shipping is the ultimate solution if you are on SQL
Server Enterprise Edition. Follow these Resources..
Log Shipping in SQL Server 2000 - Part 1
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
Log Shipping in SQL Server 2000 - Part 2
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
How to Perform SQL Server Log Shipping
http://www.sql-server-
performance.com/sql_server_log_shipping.asp
HTH
THIRUMAL REDDY MARAM
Sys Amin / SQL DBA

quote:

---

>--Original Message--
>I have TWO networked servers; one production, and one

---

backup. I want to be

quote:

---

>able to use the backup in case of a production server

---

failure. The loss of

quote:

---

>a "little" data is acceptable in case of failure. Log

---

Shipping looks like

quote:

---

>the easiest but there seems to be a lot of warnings about

---

(1) having a

quote:

---

>monitor server, and (2) having this server NOT be either

---

the production

quote:

---

>server nor the backup. I only have two servers so I

---

can't do this.

quote:

---

>Is Log Shipping the best solution? Also--and this might

---

affect your

quote:

---

>response--it is possible that the backup system might

---

not be available 100%

quote:

---

>of the time. I bring this up because I don't know what

---

will happen if the

quote:

---

>production system wants to ship a log, and the backup

---

computer isn't

quote:

---

>available to accept it. (')
>Any help, recommendations?
>TIA,
>Larry Woods
>
>.
>

---

Thanks, Thirumal,
I've printed off all three articles and I will study them.
Larry
"Thirumal" <treddym@.hotmail.nospam.com> wrote in message
news:129a01c3df61$ab5c71d0$a601280a@.phx.gbl...[QUOTE]
> Hi Larry,
> Log Shipping is the ultimate solution if you are on SQL
> Server Enterprise Edition. Follow these Resources..
> Log Shipping in SQL Server 2000 - Part 1
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> Log Shipping in SQL Server 2000 - Part 2
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> How to Perform SQL Server Log Shipping
> http://www.sql-server-
> performance.com/sql_server_log_shipping.asp
> HTH
> --
> THIRUMAL REDDY MARAM
> Sys Amin / SQL DBA
> backup. I want to be
> failure. The loss of
> Shipping looks like
> (1) having a
> the production
> can't do this.
> affect your
> not be available 100%
> will happen if the
> computer isn't