Academic Journals Database
Disseminating quality controlled scientific knowledge

Improving the Performance of Servers by Implementing the Manual Log Shipping for Large Databases

Author(s): Vinit Lohan | Anil

Journal: International Journal of Computer Science and Management Studies
ISSN 2231-5268

Volume: 12;
Issue: 02;
Start page: 41;
Date: 2012;
VIEW PDF   PDF DOWNLOAD PDF   Download PDF Original page

Keywords: Replication | backup | recovery | hot backups | online

Business success, the need to ensure 24x7availability is greaterthan it has ever been. One common method for as databasesystems become more and more critical to providing 99.99%, or"4-nines" availability, is to implement a "warm" standby databaseserver. The use of standby servers is not a new concept; databaseadministrators (DBAs) have been using them for years. Typically,standby servers require the DBA or operator to create backups ofthe database and logs on the primary system and then restorethese backups on a standby server on a regular basis. If theprimary server fails, the down time is isolated to the amount oftime required to process the log files since the last backup wasrestored on the standby server.Log shipping allows you to automatically send transaction logbackups from a primary database on a primary server instance toone or more secondary databases on separate secondary serverinstances. The transaction log backups are applied to each of theSecondary databases individually. An optional third serverinstance is known as the monitor server records. The history andstatus of backup and restores operations and, optionally, raisesalerts if these operations fail to occur as scheduled.We can improve the functionality of our Log Shipping manuallyso that back up is made quickly and making it quick, we insertsome manual codes. Implementing Log Shipping for smalldatabases is relatively straightforward as one can easily do itusing the GUI but for large database, the GUI is not a goodoption as the database on the destination server will be alwaysout of sync. So a question arises how do we accomplish this task?In this paper, we are going to explain you the detailed stepswhich we followed to implement the log shipping for our largedatabases manually and improving the performance of ourservers.

Tango Rapperswil
Tango Rapperswil

     Affiliate Program