Log Shipping in SQL Server
Log Shipping in SQL Server
Log Shipping
Primary database Server
This server contains the primary database .The backup of the transaction logs of the Primary database is taken on this server and send to the Secondary database server.
Secondary database Server
This server contains the secondary database . There can be one or more than one secondary database server. Here backup of the primary database server transactions log are applied to the secondary database server databases individuality so that they have database which is close to the Primary server database.
Monitor Server
This optional server, monitor the log shipping process by recording the history and the status of the the backups of the transaction logs. It also monitor the restore operations on the secondary server. It can also raise alarm if the process is not completed as per scheduled.
Share this:
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
About The Author
vivekjohari
I am currently working as a Senior Database Professional and have around 18 years of experience in database. Degree:- Master Degree in Computer(MCA) Certification course in Data Science & Machine Learning from Indian Institute of Technology (IIT), Delhi Work experience:- Designing of the database. Database Optimization. Writing Complex Stored Procedures,Functions,Triggers etc. Designing and developing SSIS & DTS packages. Designing SQL Reports using SSRS. Database Server Maintenance. Certification:- MCTS: DA-100: Analysing Data with Microsoft Power BI MCTS: DP-300: Administering Relational Databases on Microsoft Azure Microsoft certified Sql DBA in Sql server 2008 (MCTS). Microsoft certified BI professional in Sql server 2008 (MCTS). Oracle certified profession DBA in ORACLE 10g (OCP) certified profession DBA in ORACLE 9i (OCP) My other publication Technical Blog:- Technologies with Vivek Johari Guest Author and Blogger at sqlservercentral.com