Pages

▼
Friday, 30 September 2016

Creating alerts for monitoring proactively SQL Server AlwaysOn Availability Groups

›
When it comes to monitoring databases we have to do it proactively by using alerts implemented natively or via T-SQL code inside SQL Jobs ru...
Thursday, 29 September 2016

Using ‘sp_browsereplcmds’ to Diagnose SQL Replication Issues

›
When diagnosing transactional replication issues in SQL Server, we may need to examine pending commands within the distribution database. In...
3 comments:
Friday, 19 August 2016

Why is the .txt history detail file of SQL Backup Job not created?

›
Clearly, we always need to have some kind of history for SQL Backup jobs in order to check whether or not they were executed correctly. I pe...
Thursday, 21 July 2016

The 'SkipErrors' parameter for the Replication Distribution Agent

›
Having encountered numerous errors in SQL Server Replication, I can confidently say that the majority occur at the replication agent level, ...
Wednesday, 20 July 2016

How to query the windows users that access via windows groups from SQL Server

›
At times while monitoring a database server, we may need to know not only which SQL users are accessing, but also windows users for securit...
Saturday, 16 July 2016

SQL Mirroring Port could stop working unexpectedly

›
When it comes to diagnosing and fixing some SQL Mirroring issues we may have to face with bizarre causes that could stop working a database ...
Thursday, 30 June 2016

Error 20598: The row was not found at the Subscriber when applying the replicated command

›
Having transactional replication environments with read-only subscribers (which means that changes are not propagated back to the publisher)...
Friday, 3 June 2016

How to move the files of database which has Replication, Mirroring, Log Shipping or AlwaysOn Settings

›
One of the challenging tasks in the life of a DBA is definitely moving all or some of the files of a database from one physical location to ...