How to Unlock Locked SQL Server Logins
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the SQL Server instance even…
Read MoreSQL Server Audit File Enabled for Both Failed and Successful Logins
SQL Server Audit File Enabled for Both Failed and Successful Logins Introduction During a routine SQL Server security review, it was observed that SQL Server Audit was configured to capture both FAILED_LOGIN_GROUP and SUCCESSFUL_LOGIN_GROUP events. While…
Read MoreReplication snapshot agent permission issue and Troubleshooting
Replication snapshot agent permission issue and Troubleshooting 1. What is the replication for the SQL server? SQL Server replication is one of the HADR technologies that copy and distribute the data…
Read MoreSQL servers’ registration in SSMS
SQL servers’ registration in SSMS What is server registration in SSMS? It is one of the features in SQL Server Management Studio (SSMS) which is very useful to have a list of registered servers…
Read MoreFailover issues in Always-on AG
Failover issues in Always-on AG What is failover in always-on AG in SQL server.? In SQL Server Always On Availability Groups (AG), failover is the process of switching the…
Read MoreSA account is locked in sql server
SA account is locked in SQL server What is SA account in SQL server.? The “SA” (system administrator) account in SQL Server is a highly privileged, built-in account with…
Read MoreRead permission on secondary replica in always-on AG
How to give read permission on secondary replica in always-on AG Purpose of Log shipping: Always On availability groups feature is a high-availability and disaster-recovery solution that provides an…
Read MorePermission on secondary database in loginshipping
How to give read permission on secondary server in log shipping Purpose of Log shipping: SQL Server Log shipping allows databases to automatically send transaction log backups from a…
Read MoreRestoration job failed in Log shipping
What is Log shipping? SQL Server Log shipping is an automatic process that sends transaction log backups from a primary database server instance to secondary databases server on secondary server instances.…
Read MoreTempDB full issue
TempDB Files space issue What is the purpose of tempdb in SQL server.? Ans: Tempdb is a temporary database which contains tables data for temporary purpose SQL Server PDW system…
Read More