Log Shipping from SQL Server 2000 Enterprise to SQL Server 2005 Standard

Is it possible to set up Log Shipping from SQL Server 2000 Enterprise
to SQL Server 2005 Standard? If not I am ready to downgrade the 2005
to 2000 standard. Thanks for any suggestions.
RBollingerHi Rob
"robboll" wrote:
> Is it possible to set up Log Shipping from SQL Server 2000 Enterprise
> to SQL Server 2005 Standard? If not I am ready to downgrade the 2005
> to 2000 standard. Thanks for any suggestions.
> RBollinger
>
I am not a log shipping expert, but reading between the lines of
http://msdn2.microsoft.com/en-us/library/ms188297.aspx it seems you can log
ship from SQL 2000 to SQL 2005, but once you have failed over to SQL 2005
there is no going back, and SQL 2005 can not ship back to SQL 2000.
John|||On Apr 4, 1:00 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rob
> "robboll" wrote:
> > Is it possible to set up Log Shipping from SQL Server 2000 Enterprise
> > to SQL Server 2005 Standard? If not I am ready to downgrade the 2005
> > to 2000 standard. Thanks for any suggestions.
> > RBollinger
> I am not a log shipping expert, but reading between the lines ofhttp://msdn2.microsoft.com/en-us/library/ms188297.aspxit seems you can log
> ship from SQL 2000 to SQL 2005, but once you have failed over to SQL 2005
> there is no going back, and SQL 2005 can not ship back to SQL 2000.
> John
Good answer -- thanks|||On Apr 4, 1:00 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rob
> "robboll" wrote:
> > Is it possible to set up Log Shipping from SQL Server 2000 Enterprise
> > to SQL Server 2005 Standard? If not I am ready to downgrade the 2005
> > to 2000 standard. Thanks for any suggestions.
> > RBollinger
> I am not a log shipping expert, but reading between the lines ofhttp://msdn2.microsoft.com/en-us/library/ms188297.aspxit seems you can log
> ship from SQL 2000 to SQL 2005, but once you have failed over to SQL 2005
> there is no going back, and SQL 2005 can not ship back to SQL 2000.
> John
As a follow-up question. If the secondary server is SQL Server
Standard (Personal Edition) will that work? The primary server is SQL
Server 2000 Enterprise Edition with the log shipping functionality.|||Hi Rob
"robboll" wrote:
> On Apr 4, 1:00 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi Rob
> >
> > "robboll" wrote:
> > > Is it possible to set up Log Shipping from SQL Server 2000 Enterprise
> > > to SQL Server 2005 Standard? If not I am ready to downgrade the 2005
> > > to 2000 standard. Thanks for any suggestions.
> >
> > > RBollinger
> >
> > I am not a log shipping expert, but reading between the lines ofhttp://msdn2.microsoft.com/en-us/library/ms188297.aspxit seems you can log
> > ship from SQL 2000 to SQL 2005, but once you have failed over to SQL 2005
> > there is no going back, and SQL 2005 can not ship back to SQL 2000.
> >
> > John
> As a follow-up question. If the secondary server is SQL Server
> Standard (Personal Edition) will that work? The primary server is SQL
> Server 2000 Enterprise Edition with the log shipping functionality.
>
I would expect there are licencing issues if you used personal edition for
this, expecially if you failed over to it. In general if your failover
hardware/software is not the same specification as the primary system you may
have issues that negates the reason for trying to maintain high availabilty
i.e. you can not continue with a suitable level of service.
John