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 MoreHow 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 MoreWhat 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 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 MoreIdentify 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 MoreControlling 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 MoreAdding 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 MoreWhat 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 MoreResource Database Corruption: What is resource database: Resource database is a binary and a system database, and its corruption would not allow instance to start. If resource database is corrupt…
Read MoreSlipstream in SQL Server What is the slipstream how to use slipstream to install SQL server? Slipstream is a technique used by System Admins to easily update the setup packages…
Read More