How to configure Log shipping on SQL server 2000 developer edition

Rajendra,
you should be able to use the log shipping wizard to set
things up. If you do need to script it out, then you
could use profiler while the wizard runs, but the main
part will be in the maintenance plan, which is not
scriptable in the usual meaning of the word.
Rgds,
Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Thanx for ur reply but I don't have Enterprise edition. We purchased the
developer edition because Log shipping feature was listed in the available
features of SQL server 2000. If it is not available in developer edition then
Why Microsoft claimed to have this feature in developer edition?
"Paul Ibison" wrote:

> Rajendra,
> you should be able to use the log shipping wizard to set
> things up. If you do need to script it out, then you
> could use profiler while the wizard runs, but the main
> part will be in the maintenance plan, which is not
> scriptable in the usual meaning of the word.
> Rgds,
> Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Rajendra,
this facility should be there as developer is essentially
the same functionalitywise as enterprise edition and I
have just checked on a box at work. If you start the
maintenance plan wizard, and the log-shipping checkbox is
disabled for a particular database, this is because the
database is in simple recovery mode - perhaps this is the
case? Also, can you do select @.@.version just to confirm
that you have the developer edition installed.
Rgds,
Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||It is not installed in the developer edition, only the EE one.
I suggest Rajendra check out this link for info on how to set it up without
using EE.
http://www.sql-server-performance.co...g_shipping.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:01fa01c4ba7e$668d7a10$a401280a@.phx.gbl...
> Rajendra,
> this facility should be there as developer is essentially
> the same functionalitywise as enterprise edition and I
> have just checked on a box at work. If you start the
> maintenance plan wizard, and the log-shipping checkbox is
> disabled for a particular database, this is because the
> database is in simple recovery mode - perhaps this is the
> case? Also, can you do select @.@.version just to confirm
> that you have the developer edition installed.
> Rgds,
> Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||AFAIK it is installed with Enterprise, Developer and
Enterprise Evaluation Editions - I can see the options on
my desktop, which only has Developer Edition.
Rgds,
Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I'm sorry, I just realized that this laptop has standard edition SQL Server.
I'll take your word for it Paul! Thanks for the clarification.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:0c2d01c4ba9a$9095e8d0$a601280a@.phx.gbl...
> AFAIK it is installed with Enterprise, Developer and
> Enterprise Evaluation Editions - I can see the options on
> my desktop, which only has Developer Edition.
> Rgds,
> Paul Ibison, SQL Server MVP, WWW.Replicationanswers.Com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>