In this article, we look at backup checksums, how
they help and how to deal with media errors that arise when performing backups.
Apart from simply performing backup operations to safeguard your data, SQL Server also allows you to ensure that your backup data’s integrity is maintained. To make sure that the data you are backing up is free of errors, you can opt for creating a backup checksum. And depending on the kind of checksum used, you can identify problems with your backups if there...
Read more »
This article addresses the installation error ‘A Constraint Violation Occurred’ and how users can solve it.
This is among the most common problems witnessed by most people while installing SQL Server in Windows. Usually, this error occurs when the setup SQL Server Cluster creates a failover cluster manager with a network name resource which automatically leads to a fail. Programmers often find themselves caught up with an error which slows down their work speed. This violation is...
Read more »
In
this article, we look at roles being used to grant permissions on the report
server. We also look at who sets these permissions how these permissions are
stored.
Reporting Services in SQL Server use a role-based authorization and authentication subsystem in order to determine the users who can perform an operation or access items on a report server. Role-based system is used for categorizing authorization of different roles and action which can be performed by a user or a group. This...
Read more »
