Tags » AlwaysOn

Hybrid: SQL AlwaysOn Availability Group

Giải pháp AlwaysOn Availability Group luôn cung cấp cho một nhóm database của bạn tính sẵn sàng cao bằng cách thêm vào 1 bản sao chép. 1,284 more words

#azure

AlwaysOn availability groups

Always on Availability groups offer the best in redundancy offered by Microsoft.  They are rock solid, relatively straightforward, and can be set up by a good DBA in hours. 25 more words

AlwaysOn

Failover Time-Prediction

In the previous post, we learned the basic definition of SQL’s new feature AlwaysOn and the various events that occur when a failover happens.

Today, we will learn how SQL Database engine predicts the time involved during the failover which can be very helpful for deciding the… 756 more words

AlwaysOn

AlwaysOn Failover Cluster- Explanation

To Start learning about the new SQL Server 2012 feature AlwaysOn lets start with basic study about the Windows Server Failover Clustering.

WSFC is a server feature which is used for the high availability for the critical applications. 333 more words

AlwaysOn

SQL\PowerShell - How to add database into an availability group

Using PowerShell, connect to the primary replica and run the following commands

Import-Module SQLPS

$DatabaseBackupFile = “\\server\shared_folder\<database_name>.bak”
$LogBackupFile = “\\server\shared_folder\<database_name>.trn”
$MyAgPrimaryPath = “SQLSERVER:\SQL\InstanceSQL1\AvailabilityGroups\availability_group_name”
$MyAgSecondaryPath = “SQLSERVER:\SQL\InstanceSQL2\AvailabilityGroups\availability_group_name” 62 more words

Powershell

Synchronize Logins on AlwaysOn Replicas

–By Lori Brown   @SQLSupahStah

At one of my clients who has an AlwaysOn failover cluster, I noticed as I was checking up on things on the secondary replica that there were several fewer Windows and SQL logins on the secondary than on the primary. 1,354 more words

SQL Server

My Top 5 Phone Apps

10% – that’s the percentage of phone apps I use on a regular basis. I guess most people are guilty of the same. That part when you download one and you don’t want to remove it because you think you might be able to use in the future. 526 more words

Life