January 26, 2009 at 3:55 pm
Currently on SQL 2000. Will be upgrading to 2008 later this year.
Immediately, I want to setup log shipping between our production server and a fail-over server. We also have separate servers for Staging, Test and Dev.
I have built my own log shipping routine for another smaller server, but I don't want to implement that on this much larger server.
What I would like to gather is a non-bias (if that exists) opinion about setting up log shipping. I hear a lot about Quest's LiteSpeed solution for Log Shipping, but that would be quite an expensive solution given I would basically need some form of license on all the other servers I have that we want to restore to.
The database is currently 300GB and growing. Our log backup can grow up to 30GB.
Thank you in advance!
January 26, 2009 at 4:04 pm
I use a log shipping set up supplied with the BORK (back office resource kit), its written by MS employees, uses SQL Agent jobs and sqlmaint and works extremely well and is simple and well designed, in fact I prefer it to the enterprise edition offering (2000 or 2005)
It is not 2005/2008 compatible but is FREE, so a good temporary solution
Whatever option you choose you will have the problem of initialising log shipping via the full restore. Best make sure network is good.
not sure of a URL for it (there are some set up scripts and description of process) but search for 'Installing Log Shipping for SQL 7.0' by Natasha Huggins.
---------------------------------------------------------------------
January 26, 2009 at 4:48 pm
Thank you much, George! But first the most tricky part, apparently... finding that Resource CD!
January 27, 2009 at 3:19 am
this URL appears to have a link to the code -
http://www.sqlmag.com/Article/ArticleID/15804/sql_server_15804.html
any problems give me a shout I can send you everything needed to set it up.
Note - the srticle talks about SQL 7.0 which this method was designed for, so it comes from the SQL 7.0 BORK, but don't worry , it works on SQL 2000.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply