Database Recovery

How to Solve “Event ID not found” Error in SQL Server

In this article, we explain solutions to the SQL Server error for ‘Event ID not found’. Apart from all its features and functions, SQL Server can also be a storehouse of confusion if you are not very familiar with all that it provides and what all it can be used for. For all the events and operations that we perform in SQL Server, we can refer to the event log for details. But keeping in mind the high-end features and some complexities of the application, there might also be times when...

Read more »

How Permissions can be Granted in SQL Server Report Service

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 »

How to Find out the Time Points When Someone Checks Database Consistency in SQL Server

There are several database consistency checker commands. It is recommended that we should rarely execute FREEPROCCACHE in production environments. In this article, we will learn how to identify when database consistency checker commands were executed in your production environment. Using SSMS Messages available in the SQL Server Error logs can be an information or an error. At the time of an issue, this error log will help you to investigate quickly. To identify when was the DBCC...

Read more »