Log Shipping Essay, Research Paper
The concept of standby servers is not a new one. It has been around a long time and been used by many DBAs. Traditionally, using a standby server for failover has involved manually making database and log backups on the production server and then restoring them to the standby server on a regular basis. This way, should the production server fail, then users could access the standby server instead, and downtime and data loss would be minimized.
What is Log Shipping
Essentially, log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. This in effect keeps the two SQL Servers in “synch”.
Problems with Log Shipping
log shipping is a compromise. It is not the ideal solution, but it is often a practical solution given real-world budget constraints. Some of the problems with log shipping include:
+ Log shipping failover is not automatic. The DBA must still manually failover the server, which means the DBA must be present when the failover occurs.
+ The users will experience some downtime. How long depends on how well you implemented log shipping, the nature of the production server failure, your network, the standby server, and the application or applications to be failed over.
+ Some data can be lost, although not always. How much data is lost depends on how often you schedule log shipping and whether or not the transaction log on the failed production server is recoverable.
+ The database or databases that are being failed over to the standby server cannot be used for anything else. But databases on the standby server not being used for failover can still be used normally.
+ When it comes time for the actual failover, you must do one of two things to make your applications work: either rename the standby server the same name as the failed production server (and the IP address), or re-point your user’s applications to the new standby server. In some cases, neither of these options is practical.
Log Shipping with SQL Server 7.0
In the past, SQL Server developers and DBAs have had to create customized scripts to implement log shipping. But with SQL Server 7.0, Microsoft provided undocumented hooks into the extended stored procedure xp_sqlmaint to help automate log shipping. The Microsoft BackOffice 4.5 Resource Kit (BORK) Log Shipping utility consists of scripts and instructions that use these hooks into xp_sqlmaint for creating a mostly automated log-shipping solution. You can get BORK from Microsoft Press for $250 retail (about $130 street price).
Microsoft developed the BORK Log Shipping utility, as it did all its resource kit utilities, for internal use at Microsoft; Microsoft Product Support doesn’t support the utility. And you’ll find the BORK Log Shipping utility rough around the edges. Although it automates much of the log-shipping process, the utility requires a fair amount of manual setup and administration. However, SQL Server 2000 Enterprise Edition fully supports log shipping and provides a more polished interface than the BORK utility.
In a log-shipping implementation, failing over to the standby server is a manual process. If you require automated failover, a better solution is Microsoft Cluster Services (MSCS), which automatically fails over one cluster node to another cluster node. However, the clustering solution costs more than log shipping, requires additional specialized hardware, and forces a closer coupling, or dependency, of primary and secondary servers. To set up log shipping, all you need is the BORK utility, enough disk space on your production and standby servers to store the database and transaction log backup files, and a network connection between the servers.
Log Shipping with SQL Server 2000
SQL Server 2000 Enterprise Edition fully supports log shipping setup and monitoring. The Enterprise Edition’s Database Maintenance Plan Wizard includes a check box on the Transaction Log Backup dialog box that lets you specify shipping the log to another server. To use this option, you must first establish file shares on the source and destination servers for the transaction log folders. The wizard will then perform the full database backup and restore, create the transaction log backup job, and create the jobs on the destination server that copy and load the backups.
As with the Microsoft BackOffice 4.5 Resource Kit (BORK) Log Shipping utility for SQL Server 7.0, these log-shipping jobs call the xp_sqlmaint extended stored procedure to perform their tasks. The wizard also creates alert jobs for the copy and load operations; these jobs call the same monitoring stored procedures as the BORK utility calls. However, the stored procedures and tables underlying SQL Server 2000’s log-shipping functionality differ from and have more consistent names than the stored procedures and tables that provide the BORK functionality. SQL Server 2000 has seven tables to BORK’s three and has four stored procedures for monitoring.
Overall, the SQL Server 2000 system is more polished than the BORK version. With SQL Server 2000, you can monitor log shipping through the Enterprise Manager instead of through the stored procedures. When you set up log shipping, the Database Maintenance Plan Wizard places a Log Shipping Monitor in the Management node of the server you specify. This monitor consists of a Tab dialog box that lets you observe log shipping’s status and change settings for the source and destination servers. You can also view copy and load histories by right-clicking the Log Shipping Monitor in the details pane.
Like SQL Server 7.0, SQL Server 2000 doesn’t offer automated support for failover or for changing the servers’ roles so that log shipping goes the other direction. Instead, SQL Server 2000 supplies four stored procedures to assist in the failover process and relies on a new built-in Data Transformation Services (DTS) feature to transfer logins from the source to the destination server. You can use the stored procedures to resolve the logins on the former standby server, to change the servers’ roles, and even to change which server the Log Shipping Monitor resides on.
Другие работы по теме:
Mcluhan Essay Research Paper While many McLuhanites
Mcluhan Essay, Research Paper While many McLuhanites consider the concept of the Global Village to be prescient, especially in terms of “predicting” the Internet, it is ludicrous to thus “Nostradamus-ize” McLuhan, leaving us to interpret each phrase in terms of some event or invention, nodding sagely at his brilliance each time we make a connection.
Historical Fiction Essay Research Paper Textbooks can
Historical Fiction Essay, Research Paper Textbooks can often prove to offer only a limited amount of information. Space and time constraints place the author(s) of these textbooks in a sticky situation. They must get the general concept through without taking up to much space. However, this can sometimes push out relevant material that van help to support the general concept.
Make And Toke Your Own BONGS Essay
, Research Paper ********************************* * MAKE AND TOKE YOUR OWN BONGS! * ********************************* BY TONY MARX ==> A guide for everyone on the art of making bongs, from the
Science And War Essay Research Paper Schopenhauer
Science And War Essay, Research Paper Schopenhauer had an understanding of the Will, which has to separate parts. The Will to Life and Human Will. The Will to Life, was the over all striving that
Hairdini Essay Research Paper Advertising
Hairdini Essay, Research Paper Advertising & Distribution Our product is the Hairdini magic styling wand, that is used for your hair to make French twists or buns or as they say ?fashionable hairstyles.? We found the product after looking in many stores and after finally giving up. Then when we had stopped looking we found the product in our home, our mother had bought it a year ago after seeing it on television.
Thomaas Edison Essay Research Paper Dear DadI
Thomaas Edison Essay, Research Paper Dear Dad, I have taken your request for a Christmas list to heart and have decided to get right on top of it. So this is my Christmas list, hope you enjoy shopping for me.
Respect Essay Research Paper It is something
Respect Essay, Research Paper It is something everyone wants, not many have, and few want to give. Most people would appreciate “just a little bit,” and most should give just that. Unfortunately, a lot of the time, this does not happen. Perhaps this is because the concept of respect is not understood. What exactly is respect? The dictionary defines it as an act of giving particular attention or high or special regard.
Justice Essay Research Paper The concept of
Justice Essay, Research Paper The concept of justness is a subjective reality. Justice is not present in any one person, justice appears to be present only in consensus. There is no just,
Untitled Essay Research Paper Dear Mr Peace
Untitled Essay, Research Paper Dear Mr. Peace, The Connecticut River also known as by it s Algonquin name Long River is very rich and still useable for transportation. The chemical plant that you are proposing to put on the
The Myth Of Time Sumosaki Vs Enigma
) Essay, Research Paper Give me some time to think. You pressure me with your hourglass. Your concept, I am not supposed to believe in. But I am not given choices.
Colony Groups Essay Research Paper Colony GroupsThe
Colony Groups Essay, Research Paper Colony Groups The New England, Middle, and Southern colonies had very different viewpoints on how life was to be lived. The New England colonies believed that the society had to ’stick together’ to survive, and they were primarily based on shipping and moving of goods.
Lawgrtt Essay Research Paper The Constitution of
Lawgrtt Essay, Research Paper The Constitution of the United States and Madison’s Federalist Paper 51 draw upon the philosophy of John Locke, as expressed in his Second Treatise of Government. Madison and the framers of the Constitution looked to Locke’s ideas for justification and guidance. The Preamble of the Constitution reflects the intentions of its authors and shows the influence of Locke’s ideas.
A Streetcar Essay Research Paper Directing ConceptTennessee
A Streetcar Essay, Research Paper Directing Concept: Tennessee Williams A Streetcar Named Desire brings reality to a woman in desperate need of attention. In the production that this design team will put together from the lights to the set will be created a colorful outlook on life from the view of Blanche DuBois.
Education Learning By Communism Essay Research Paper
Education: Learning By Communism? Through Freire?s ? The Banking Concept of Education,? we see the effects this concept has on it?s students and also we see the effects that the alternate concept, problem-posing has. The ?banking? concept allows the students to become vessels of knowledge, not being able to learn at a creative pace.
Karma And Varna Essay Research Paper What
Karma And Varna Essay, Research Paper What is the relation, if any, of the concept of varna to the concept of karma? Of karma to the doctrine of reincarnation? The concepts of varna and karma are
Hawking Essay Research Paper Stephen Hawkings is
Hawking Essay, Research Paper Stephen Hawkings is the most honored physicist in out time.He has battled against what is known as Lou Gehrig s disease for some thirty years. Presently, he is unable to communicate without his computer, but Hawkings is still very active in the field.
Lone Man Essay Research Paper Thank you
Lone Man Essay, Research Paper Thank you for your interest in NetZero. As part of our commitment to maintain high quality, free Internet access for all of our users, we are currently limiting the number of new downloads of our software on a daily basis.
Jefferson Vs Hamilton Essay Research Paper Between
Jefferson Vs Hamilton Essay, Research Paper Between Jefferson and Hamilton the two both wanted what was best for the newly formed country but just had different opinions on how to go about it. Hamilton wanted the United States to be governed by an aristocracy while Jefferson had his faith in the people and disagreed with Hamilton.
Societal Marketing Concept Essay Research Paper The
Societal Marketing Concept Essay, Research Paper The societal marketing concept holds that the organisation should concentrate on the needs and wants of their customers, and then deliver the desired satisfactions more effectively and efficiently than competitors, in a way that maintains or improves the consumer’s and the society’s well-being.
Marriage Essay Research Paper In the United
Marriage Essay, Research Paper In the United States most Americans have trouble understanding the concept of an arranged marriage. Arranged marriages not only affect individuals, but also society. I believe that arranged marriages are better then personal choice marriages. I came to this conclusion on the basis of other cultures other then the culture of the United States.
Style Essay Research Paper I am choosing
Style Essay, Research Paper I am choosing to write about paragraph two, page 95 of the Hebidge article. I agree that taste does distinguish those who make the distinctions.
Ford Essay Research Paper Concept car todayThey
Ford Essay, Research Paper Concept car today? They can start out as simple as a dream, or a sketch on a napkin during lunch. But by the time you see them, vehicles from Ford Motor Company have been designed and tested to look and perform their best. Here are some stories that chronicle that process.
Asdfasf Essay Research Paper font facetahoma size4
Asdfasf Essay, Research Paper *font face=tahoma size=4 color=red**b*Leblanc Normandy Clarinet – 1964.*/b* *font face=tahoma size=2 color=black*Plastic. All original pieces and parts*br**br* *B*RARE*/B* *font color=red**b*Special Edition – Plateau keys!!!*/b**/font color**br*
Concept Cars Essay Research Paper Concept CarsTo
Concept Cars Essay, Research Paper Concept Cars To be known in the future you have to think ahead into the future. This is why concept cars have become so popular in the past couple of decades. Not many people succeed in making a successful concept car; which are also known as a prototype.
Carl Rogers Essay Research Paper July 28
Carl Rogers Essay, Research Paper July 28, 2000 Dr Finkel Theories and Therapy Concept of of a Fully-Functioning Person Carl Rogers was a psychotherapist who, in the early part of the twentieth Century, developed the concept of client-centered psychotherapy. He was a great proponent of the scientific method and was one of the first to incorporate it into psychotherapy.
International Logistics Essay Research Paper Logistics is
International Logistics Essay, Research Paper Logistics is the designing and managing of a system in order to control the flow of material throughout a corporation. This is a very important part of an international company because of geographical barriers. Logistics of an international company includes movement of raw materials, coordinating flows into and out of different countries, choices of transportation, cost of the transportation, packaging the product for shipment, storing the product, and managing the entire process.
Fairness Of Jurors Essay Research Paper MUST
Fairness Of Jurors Essay, Research Paper MUST A JUROR’S MIND BE EMPTY TO BE OPEN?This article is about a concept of choosing the 12 jurors. In any case, jurors always play important roles in the court since they are the people who will come up with a verdict. Because of this, people believe that when the jurors are chosen for a certain trial, they must be aware of that case and know what is going on in that case.
Dred Scott Decision Essay Research Paper The
Dred Scott Decision Essay, Research Paper The Dred Scott decision of 1865 had many implications on the status of free blacks in the United States, along with the concept of popular sovereignty, and the future of slavery in America.
Ballroom Of Romance Essay Research Paper First
Ballroom Of Romance Essay, Research Paper First, there is the concept of ?tragic courting.?It appears that throughout both Irish film and literature, there is a prominence of tragic couples in the fruitless journey for happiness. For exampl, in ?The Ballroom of Romance,? Bowzer Egan looks to court the ?still-single-after-all-these-years? Bridy (or Bridie; whichever is the correct spelling).
Logistics Essay Research Paper Logistics played a
Logistics Essay, Research Paper Logistics played a large role in Dow Chemicals competitive advantage by, by making sure that there products arrive just in time. The have an alliance with Union Pacific which helped a lot, and with there network of trucks, barges and ships they are able to reach it to customers.
Mobile Alerts Essay Research Paper Mobile Alerts
Mobile Alerts Essay, Research Paper Mobile Alerts – Concept Paper. What is Mobile Alert? Mobile Alert is the text message (SMS) sent to a mobile phone as a result of occurrence of an event for which the mobile user has registered the request for getting the notification.
Starbucks Coffee Company Essay Research Paper CONCEPT
Starbucks Coffee Company Essay, Research Paper CONCEPT PAPER COMPANY: Starbucks Coffee Company The purpose of the video program is to orient and inform employees about the goals and objectives of the company. In addition to this, the rules and benefits of employees will be featured. The video will employ a factual style in conveying its purpose.
Civilized Man Essay Research Paper Does man
Civilized Man Essay, Research Paper Does man survive better under natural law or civilized law? When asked this question, the first thing that pops into mind is what both of these mean. Civilized law is our current position in society, and natural law exists among people who are not a part of mainstream society.