SQL Server Database Recovery

3 Key Benefits of Mirrored Backup Media Sets in SQL Server

In this article, we look at how reliability for backups can be increased with the use of Backup Media sets that are mirrored. Mirroring with a media set drastically increases the reliability of a backup by reducing chances as well as the fallout of device malfunctions. Mirroring is an essential function of SQL server as a backup is the last ray of hope which can protect the user against possible data loss. In time as the data grows, the probability of malfunctions also grows which increases...

Read more »

How to Work with Map Reports in SQL Server

In this article, we look at planning a map report using SSRS and look at several facts ranging from choosing a map type to planning for legends. A Good report is filled with statistical insights and study that motivates people to take actions. In order to present such analytical data relating to numbers or demographics or geographic background, can be presented by inserting maps in your Reporting Services. These maps can contain layers, in which each layer can signify a different...

Read more »

What are Copy-Only Backups and How to Create Them with SQL Server Management Studio

In this article, we look at the non-traditional copy-only backups and explain the steps needed to create them with SSMS A copy-only backup can be defined as a form of SQL Server backup which is independent of the conventional sequence of SQL Server backups. Usually, using a backup can make significant changes in a database, that can affect how later backups would be restored. However, sometimes it can turn out to be really useful to use a backup without affecting the original documents or...

Read more »