Posts by SaiKumar

Failover 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 More

SA 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 More

Read 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 More

Permission 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 More

Restoration 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 More

TempDB 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

Identify and remove unused indexes in SQL Server

Identify and remove unused indexes in SQL                         Server   Introduction: Indexes means order information about data, with indexes we can retrieve data from the database more quickly than otherwise. Index…

Read More

Controlling visibility of databases and server level setting by Contained Database

Controlling visibility of databases and server level setting by Contained Database Introduction: Contained Database is a new feature of SQL Server 2012. A contained database is a database that is…

Read More

Adding data file to Mirroring database

        Adding data file to Mirroring database What is Mirroring? Database mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the mirror database as…

Read More

Adding data file to Log-shipping database

What is log shipping? SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases…

Read More