warm standby instance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

warm standby instance

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
[email protected]
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>
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 />[email protected]
Read for custom log shipping… http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp
Mohammed U.
Brad McGeehee of this site has written very good articles on log shipping, search for them.
]]>