Improving the Performance of Servers by Implementing the Manual Log Shipping for Large Databases
Journal Title: International Journal of Computer Science and Management Studies (IJCSMS) www.ijcsms.com - Year 2012, Vol 12, Issue 2
Abstract
Business success, the need to ensure 24x7availability is greater than it has ever been. One common method for as database systems become more and more critical to providing 99.99%, or "4-nines" availability, is to implement a "warm" standby database server. The use of standby servers is not a new concept; database administrators (DBAs) have been using them for years. Typically, standby servers require the DBA or operator to create backups of the database and logs on the primary system and then restore these backups on a standby server on a regular basis. If the primary server fails, the down time is isolated to the amount of time required to process the log files since the last backup was restored on the standby server. Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the Secondary databases individually. An optional third server instance is known as the monitor server records. The history and status of backup and restores operations and, optionally, raises alerts if these operations fail to occur as scheduled. We can improve the functionality of our Log Shipping manually so that back up is made quickly and making it quick, we insert some manual codes. Implementing Log Shipping for small databases is relatively straightforward as one can easily do it using the GUI but for large database, the GUI is not a good option as the database on the destination server will be always out of sync. So a question arises how do we accomplish this task? In this paper, we are going to explain you the detailed steps which we followed to implement the log shipping for our large databases manually and improving the performance of our servers.
Authors and Affiliations
Anil , Parveen Yadav , Balraj Sharma , Vinit Lohan
Keywords
Related Articles
- EP ID EP135388
- DOI -
- Views 103
- Downloads 0
COMPATIBLE SERVICE RETRIEVAL USING IMPROVED SIMILARITY MEASURE
Now-a-days retrieving suitable services become a prominent need for the user. However available service retrieving mechanism uses the compatible similarity between the services so that user can get likely homogeneous ser...
How Automated Testing Tools Are Showing Its Impact In The Field Of Software Testing
As, we know that Software testing is a very vast field in Software development life cycle. In this paper, we describe that how automated testing tools are very much convenient and easy to use which also makes testing fas...
GRID COMPUTING AND FAULT TOLERANCE APPROACH
Grid computing is a means of allocating the computational power of a large number of computers to complex difficult computation or problem. Grid computing is a distributed computing paradigm that differs from traditiona...
Comparison of Software Quality Metrics for Object-Oriented System
According to the IEEE standard glossary of software engineering, Object-Oriented design is becoming more important in software development environment and software Metrics are essential in software engineering for measur...
A Comparison among Various Techniques to Prioritize the Requirements
In commercial software system development, software vendors often face the many difficulties to deal with large amount of requirements that enter the company every day. It is not possible to satisfy all the requirements...