Log Shipping question

I have SQL 2000 Enterprise edition on my production server, and SQL 2000
Standard on another server that will be used for my standby server. Can I
use Log Shipping in this case? I read I must have enterprise edition, but
do I need it on both servers?
Mike
Yes you can use log shipping.
Log shipping is a feature that is built in to the Enterprise Edition but it
is easy to set this up on your own.
314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515
323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
Paper)
http://support.microsoft.com/?id=323135
325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
http://support.microsoft.com/?id=325220
821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
http://support.microsoft.com/?id=821786
321247 HOW TO: Configure Security for Log Shipping
http://support.microsoft.com/?id=321247
329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133
Keith
"Mike" <mrfaber@.att.net> wrote in message
news:unR3RDIsEHA.3520@.TK2MSFTNGP11.phx.gbl...
> I have SQL 2000 Enterprise edition on my production server, and SQL 2000
> Standard on another server that will be used for my standby server. Can I
> use Log Shipping in this case? I read I must have enterprise edition, but
> do I need it on both servers?
> Mike
>
|||I know that log shipping is built in to Enterprise edition, and also that
you can configure it manully on standard edition, but can I use the builtin
log shipping on my production server(Enterprise Edition) to my standby
server(standard Edition) Or do they both have to be enterprise edition to
use the builtin feature.
Mike
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:%231ZNUhIsEHA.324@.TK2MSFTNGP11.phx.gbl...
> Yes you can use log shipping.
> Log shipping is a feature that is built in to the Enterprise Edition but
> it
> is easy to set this up on your own.
>
> 314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
> http://support.microsoft.com/?id=314515
> 323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
> Paper)
> http://support.microsoft.com/?id=323135
> 325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
> http://support.microsoft.com/?id=325220
> 821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
> http://support.microsoft.com/?id=821786
> 321247 HOW TO: Configure Security for Log Shipping
> http://support.microsoft.com/?id=321247
> 329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
> Errors
> http://support.microsoft.com/?id=329133
> --
> Keith
>
> "Mike" <mrfaber@.att.net> wrote in message
> news:unR3RDIsEHA.3520@.TK2MSFTNGP11.phx.gbl...
>
|||I don't know. I have never used the built in method -- I have always
created the log shipping routines myself. Call me old fashioned or call me
a control freak. Heck, I was doing this back in the SQL Server 6.5 days.
It is easy enough to set up the appropriate jobs so I always went that
route.
Keith
"Mike" <mrfaber@.att.net> wrote in message
news:%23Oa1NqJsEHA.3936@.TK2MSFTNGP09.phx.gbl...
> I know that log shipping is built in to Enterprise edition, and also that
> you can configure it manully on standard edition, but can I use the
builtin[vbcol=seagreen]
> log shipping on my production server(Enterprise Edition) to my standby
> server(standard Edition) Or do they both have to be enterprise edition to
> use the builtin feature.
> Mike
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:%231ZNUhIsEHA.324@.TK2MSFTNGP11.phx.gbl...
(White[vbcol=seagreen]
2000[vbcol=seagreen]
Can
>
sql