|
|
You're in the
sql server new users
group:Log shipping and licenses
sql server new users:
I want to set up log shipping. I have SQL 2000 Standard edition running on two instances of SQL server running on the same machine. If I installed SQL server 2000 Enterprise edition on another machine, I'd be able to take advantage of built-in log shipping functionality and it would be easier for me to set it up. Question is do I need to buy Enterprise edition for the two existing SQL installations? Or can I manage it all from one Enterprise edition, and stay with the standard edition where I am at the moment? Thanks in advance for your input, Regards, SW
If you want to use the automated log shipping wizards & routines that
come with SQL Server, they are only included in Enterprise Edition (for SQL 2000 that is; in SQL 2005 log shipping is included in all editions except Express). That means every server that participates in the topology (primaries, secondaries & monitor(s)) need to be Enterprise Edition, so you would have to upgrade both your primary instances. That said, log shipping is just automated log backup, copy & restore. With a little imagination, you can develop your own solution with some procs, and a few reputable SQL folks have (I just can't remember any links off the top of my head). Good luck. -- *mike hodgson* http://sqlnerd.blogspot.com [quoted text, click to view] SW wrote:
>Hi, > >I want to set up log shipping. I have SQL 2000 Standard edition running on >two instances of SQL server running on the same machine. >If I installed SQL server 2000 Enterprise edition on another machine, I'd be >able to take advantage of built-in log shipping functionality and it would >be easier for me to set it up. >Question is do I need to buy Enterprise edition for the two existing SQL >installations? Or can I manage it all from one Enterprise edition, and stay >with the standard edition where I am at the moment? > >Thanks in advance for your input, > >Regards, >SW > > >
Actually, the secondary will still work even if it is Standard edition.
-- Mike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. [quoted text, click to view] "Mike Hodgson" <e1minst3r@gmail.com> wrote in message news:OkLC7ksJGHA.2012@TK2MSFTNGP14.phx.gbl... > If you want to use the automated log shipping wizards & routines that > come with SQL Server, they are only included in Enterprise Edition (for > SQL 2000 that is; in SQL 2005 log shipping is included in all editions > except Express). That means every server that participates in the > topology (primaries, secondaries & monitor(s)) need to be Enterprise > Edition, so you would have to upgrade both your primary instances. > > That said, log shipping is just automated log backup, copy & restore. > With a little imagination, you can develop your own solution with some > procs, and a few reputable SQL folks have (I just can't remember any > links off the top of my head). > > Good luck. > > -- > *mike hodgson* > http://sqlnerd.blogspot.com > > > > SW wrote: > >>Hi, >> >>I want to set up log shipping. I have SQL 2000 Standard edition running on >>two instances of SQL server running on the same machine. >>If I installed SQL server 2000 Enterprise edition on another machine, I'd >>be >>able to take advantage of built-in log shipping functionality and it would >>be easier for me to set it up. >>Question is do I need to buy Enterprise edition for the two existing SQL >>installations? Or can I manage it all from one Enterprise edition, and >>stay >>with the standard edition where I am at the moment? >> >>Thanks in advance for your input, >> >>Regards, >>SW >> >> >> >> >
[quoted text, click to view]
Mike Hodgson wrote: > If you want to use the automated log shipping wizards & routines that > come with SQL Server, they are only included in Enterprise Edition (for > SQL 2000 that is; in SQL 2005 log shipping is included in all editions > except Express). That means every server that participates in the > topology (primaries, secondaries & monitor(s)) need to be Enterprise > Edition, so you would have to upgrade both your primary instances. > > That said, log shipping is just automated log backup, copy & restore. > With a little imagination, you can develop your own solution with some > procs, and a few reputable SQL folks have (I just can't remember any > links off the top of my head). > > Good luck. > > -- > *mike hodgson* > http://sqlnerd.blogspot.com Mike, I've heard that it can be done without Enterprise edition, but I don't have the skill and knowledge currently to set it up. I'd be grateful for your assistance in providing any links and other help though. Thanks,
Yeah, it can be done and some implementations are slicker than others
(it's not too difficult to implement a fairly basic set of procs that do the backups to a UNC path, pull those files over to the secondary & restore them based on the restore history tables in msdb and the backup history tables in msdb on the primary - a couple days messing around at a guess, maybe longer if you're not too familiar with the msdb system tables, etc.). From memory one of the SQL MVPs (or maybe a couple have done it) put together a poor man's log shipping solution (I don't think it's free but most likely cheaper than upgrading to Enterprise Edition). If you Google log shipping & SQL MVPs you'll probably find references to it. Can't remember who's solution it was - maybe Andrew Kelly, Adam Machanic, Aaron Bertrand, Tibor Karaszi, Uri Dimant, Erland Sommarskog, Mike Epprecht, Vyas Kondreddi, Vinod Kumar, Hari Prasad...one of those guys I think. Sorry I can't be more help than that. -- *mike hodgson* http://sqlnerd.blogspot.com [quoted text, click to view] S W wrote:
> Mike Hodgson wrote: > >> If you want to use the automated log shipping wizards & routines that >> come with SQL Server, they are only included in Enterprise Edition >> (for SQL 2000 that is; in SQL 2005 log shipping is included in all >> editions except Express). That means every server that participates >> in the topology (primaries, secondaries & monitor(s)) need to be >> Enterprise Edition, so you would have to upgrade both your primary >> instances. >> >> That said, log shipping is just automated log backup, copy & >> restore. With a little imagination, you can develop your own >> solution with some procs, and a few reputable SQL folks have (I just >> can't remember any links off the top of my head). >> >> Good luck. >> >> -- >> *mike hodgson* >> http://sqlnerd.blogspot.com > > > Mike, > > I've heard that it can be done without Enterprise edition, but I don't > have the skill and knowledge currently to set it up. I'd be grateful > for your assistance in providing any links and other help though. > > Thanks, >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |