Tag Info

New answers tagged

0

As a quick workaround ended up deleting whole cluster: PS C:\Windows\system32> Import-Module FailoverClusters PS C:\Windows\system32> clear-clusternode Clear-ClusterNode Are you sure you want to forcefully clean up cluster node SRVGNPW049? [Y] Yes [N] No [S] Suspend [?] Help (default is "Y"): Y PS C:\Windows\system32> And then recreating a new ...


2

The database on the end of log shipping has to be in NORECOVERY to accept the log backups being shipped over. A database involved in AlwaysOn Availability Group has to be removed from the group in order to be restored or set to any restoring state. So setting up log shipping to that database would require it to no longer being replicated. I would go back to ...


0

Regarding running reports from an Availability Group secondary server, you will need to license that instance of SQL Server. Since the AG requirements require identical equipment, your secondary's licensing cost will reflect the primary server's licensing cost Using the secondary server strictly for High Availability/Disaster Recovery does not require ...


3

1.When and how do we install Microsoft Updates? Using AOAGs could potentially help with this, depending on how much downtime is considered to be "too much". There is still a blip associated with switching the primary to a synchronous secondary as the clients will be disconnected (this may or may not be an issue in your environment) as the move happens. ...


2

I found my problem. I was working under the wrong assumption that the objects were automatically refreshed in Powershell. I added a "$NewPrimary.Refresh()" insinde of the while loop and that did the trick. I hope this helps someone with the same wrong assumption in the future.


1

Yes, this was fixed recently in Service Pack 2, Cumulative Update 3. Here's the KB article: http://support.microsoft.com/kb/3012182 "FIX: Log_Send_Rate column in sys.dm_hadr_database_replica_states cannot reflect the rate accurately in SQL Server 2012"


3

No. You can have Availability Groups (AlwaysOn isn't a feature, btw) across multiple subnets, but they all must reside on the same domain (even if they span data centers, continents, etc). This official document states as much for Windows Server 2008 R2, but I can assure you the same remains true for more recently released versions of Windows (emphasis ...


0

The reason why the log_send_rate (and redo_rate) is a bit tricky to comprehend and "correlate", especially when we are used to the data transfer over an uninterrupted point of time type of thinking is that these two rates are calculated during active times, not all times. In other words, the log_send_rate will adjust when there are log blocks being sent, ...


0

You can also set a single a database on a single secondary replica into "Suspend Data Movement" mode. Under the Availability Databases folder for that availability group, right click and choose "Suspend...". Data Synchronisation is a "pull" operation, by the secondary replica to the primary replica. Suspending data movement stops that. If you do this on the ...


0

I've been looking at the log_send_rate values as part of troubleshooting a latency issue we have in one of our production environments. I have proposed to Microsoft that their definition of the field is wrong, as mentioned here (http://technet.microsoft.com/en-us/library/ff877972(v=sql.110).aspx). "Rate at which log records are being sent to the secondary ...


0

Put the distributor in a virtual machine, and use the hypervisor's high availability tools. This lets you survive host hardware failure. OS problems will still cause issues, though, so for an additional level of protection, you can run clusters inside virtualization.


1

is there a risk that something can get corrupted regrading data and availability group listener No, tempdb is recreated when SQL server restarts. If your tempdb is large, Make sure to enable instant file initialization for data files only. The instructions are fine and follow the comment that I put in.(will add it in answer later)



Top 50 recent answers are included