SQL Server Performance

warm standby instance

Discussion in 'SQL Server Log Shipping' started by msadwz, Oct 26, 2006.

  1. msadwz New Member

    My company has just recently started using SQL Server 2000 Standard Edition. Please forgive me if I do not use the correct terms or seem that knowledgable. I need to setup a warm standby instance. It looks like log shipping is what I really want to use but according to my book I can only use it if I have the Enterprise Edition. Can anyone help!?

    Don Zehr
    Database Administrator
    ATA Airlines
    don.zehr@iflyata.com
  2. FrankKalis Moderator

    Enterprise Edition only offers you the GUI for log shipping. Using T-SQL commands, you can implement this also in Standard. I guess you find something when you look around here. Log shipping in not my first area of interest, but a member on my own site wrote an article on this, so I know it is possible. You don't speak German, btw? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  3. msadwz New Member

    We do have a german speaker on staff but let me look up some things first. Maybe I can come up with a list of questions and hopefully not bother you too much. Maybe you can answer this; Am I correct that I will need to setup a cold standby, instead of warm, since I'll be using the T-SQL commands? I have just started to read up on them but it looks like it is the manual way to update the database with transactions?<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Enterprise Edition only offers you the GUI for log shipping. Using T-SQL commands, you can implement this also in Standard. I guess you find something when you look around here. Log shipping in not my first area of interest, but a member on my own site wrote an article on this, so I know it is possible. You don't speak German, btw? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Don Zehr<br />Database Administrator<br />ATA Airlines<br />don.zehr@iflyata.com
  4. MohammedU New Member

  5. cb New Member

    Brad McGeehee of this site has written very good articles on log shipping, search for them.

Share This Page