Database Recovery

Log Shipping in SQL Server – A Primer

In this article we look at the concept of Log Shipping and how it works in SQL Server SQL Server 2016 comes with many high availability options and Log Shipping is one such option. This is actually a technique that incorporates two or even more instances of the server to copy a transaction log file from one server instance to another. As a user, you must note that this unique feature involves not only transferring the log files but also restoring it automatically on different servers. Learn...

Read more »

Learn the scope of SQL Server High Availability Options

The SQL Server Database application boasts of an array of high availability options Availability is undoubtedly one of the most important tasks for a database administrator but the key lies in choosing the best suitable options that are designed for different purposes. In other words, if you are worried to use a high availability solution for your SQL Server Database, then you must know about the five SQL Server High Availability Options. Keeping this in mind, we are here to enlighten you...

Read more »

Introduction to Database Mirroring from the perspective of a SQL Server User

In this article we discuss the concept of Database Mirroring with special emphasis on its implementation in SQL Server Now, that Microsoft has launched its SQL Server 2016, it’s time to learn about its interesting features like Database Mirroring. For those of you are still unaware of what database mirroring is like, let us acquaint you with it. Database mirroring is actually a way to increase the availability of an SQL Server Database. You must also know that this feature is implemented...

Read more »