Database Solutions

How to Use the Copy Database Wizard in SQL Server

In this article, we look at the features of the copy database wizard for moving objects from one SQL instance to another. We further look at restrictions and tips to get past them. A SQL Server instance comprises of several objects, and if you ever you need to move those objects from the given instance to another then manually transferring them will not be a wise thing to do. For transferring your SQL objects from one instance to another you should make use of the Copy Database Wizard....

Read more »

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 »