Tag Archives: always on

Using SQL Snapshot backups along with Availability group

Snapshot backup is beautiful option during releases and deploying changes specially when the database size is large like few hundreds of GBs. We have a practice to take snapshot backup during the release and delete once testing is completed on … Continue reading

Posted in Productivity, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , | Leave a comment

TSQL to add a database to existing Availability group

Following are the TSQL statements that can be used to add database into existing Availability group.

Posted in High Availability, Productivity, SQL, SQL Server, Uncategorized | Tagged , , , | Leave a comment

How to give access to Users in Secondary Always-On/Mirror Server

When we need to provide access to users on a secondary database we will be able to create a login but not user on the read-only database. To address the problem we need to create the Login with same SID … Continue reading

Posted in High Availability, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment