Friday, March 30, 2012

Log Shipping using SQL Server Standard

I'm trying to implement Log Shipping to my database but I
am running SQL Server Standard. I understand that SQL
Enterprise edition has this built into it, but we
currently can't perform an upgrade. How can I do this in
the standard edition, or how can I get access to the jobs
and store procedures or any other objects that get
created using the enterprise edtion so that I can
implement log shipping using the standard edition?
Thanks in advanced,
Vichttp://www.sql-server-performance.com/sql_server_log_shipping.asp
"Vic" <vduran@.specpro-inc.com> wrote in message
news:025b01c3d496$d9112bf0$a401280a@.phx.gbl...
> I'm trying to implement Log Shipping to my database but I
> am running SQL Server Standard. I understand that SQL
> Enterprise edition has this built into it, but we
> currently can't perform an upgrade. How can I do this in
> the standard edition, or how can I get access to the jobs
> and store procedures or any other objects that get
> created using the enterprise edtion so that I can
> implement log shipping using the standard edition?
> Thanks in advanced,
> Vic|||Hi Vic.
A couple of more alternatives for you are:
(a) http://sqlguy.home.comcast.net/logship.htm
(b) There's also a log shipping utility in the SQL Server Resource Kit which
you can downlaod from msdn if you're got a subscription.
These can be used with SQL Standard edition. You may even find others if you
spent some time searching the web..
HTH
Regards,
Greg Linwood
SQL Server MVP
"Vic" <vduran@.specpro-inc.com> wrote in message
news:025b01c3d496$d9112bf0$a401280a@.phx.gbl...
> I'm trying to implement Log Shipping to my database but I
> am running SQL Server Standard. I understand that SQL
> Enterprise edition has this built into it, but we
> currently can't perform an upgrade. How can I do this in
> the standard edition, or how can I get access to the jobs
> and store procedures or any other objects that get
> created using the enterprise edtion so that I can
> implement log shipping using the standard edition?
> Thanks in advanced,
> Vic

No comments:

Post a Comment