MSSQL

I will configure SQL Server AlwaysOn Availability Groups step by step in this article. First I want to tell about SQL Server Alwas ON. What …

  Sometimes you may want to execute a script in more than one instance. It is a solution to connect to each instance individually, but …

  Step 1: Create SP sp_help_revlogin on master database of Source / Primary instance The following script create two stored-procedures. You will use the first one …

  Sometimes you may need to restart one of the Always On servers. In such a case, you will need to failover the Availability Group …

  Sometimes you may need to restart one of the servers you use Always ON. Suppose you have 2 servers and that you have 10 …

  If you define the availability group asynchronous in the SQL Server Always ON architecture, the secondary database is slightly behind. You can find details …

  Sometimes we need to take backups on an AG basis. Finding databases that are included in individual AG and getting their individual backups will …

  In this article We create a share on a server and then we map this share on a server. I selected MSSQL as Category. …

  In Always On Availability Group Architecture, you can read from the Secondary Server. So how do you use it in your applications? In this …

  As you know, when you define SQL Server services through sql server configuration manager, they are automatically authorized with the minimum privileges they may …