Replication to establish warm Standby

Using SQL Sever 2k. Anyone seeing a problem with use of transactional replication to establish warm Standby Server. The only problem that I am aware of would be user defined data types.Aleksandar,
Transactional replication can be used for the purpose you want. I would,
possibly, caution that replication appears to be one of the SQL Server more
"delicate" abilities in that, from my experience, it is "prone" to breaking
under a number of circumstances. However, in a reasonably stable
environment, you should probably be okay. Do keep in mind that transactional
replication will not by itself automatically failover to the replicated
server if your primary server goes down for any reason. If your primary
server does fail, the replicated server will require manual intervention in
order to allow your users to access it as if it were your primary server.
For a rather comprehensive list of options of maintaining database
availability, along with the associated pro's, con's and costs, I recommend
picking up a copy of the book "Microsoft SQL Server 2000 Resource Kit" from
Microsoft Press. Part 4, "Availability" covers the topic, I believe, better
than any other write up than I've encountered to date.
Chief Tenaya
"Aleksandar" <anonymous@.discussions.microsoft.com> wrote in message
news:2867FCF4-6B75-45CD-ABF3-0F338C4FE5B9@.microsoft.com...
> Using SQL Sever 2k. Anyone seeing a problem with use of transactional
replication to establish warm Standby Server. The only problem that I am
aware of would be user defined data types.
>|||Log Shipping it is. This is exactly what I was looking for. Great help, thank you for replay.