I am not familiar with these commandlets/classes but it would seem logical that it set the database offline. I do not know if the Provision method would be...

When I see these virtual disk file names it is our Veritas NetBackup running, the client/agent is configured to run a backup, but I only see this about once per...

Microsoft has a tool for that

https://gallery.technet.microsoft.com/scriptcenter/Get-SQL-Server-Product-4b5bf4f8

Could be useful if you have multiple licenses and you need to validate which license is used on each server.

You might want to set $ErrorActionPreference in the script or use –ErrorAction on the commandlet

http://blogs.technet.com/b/heyscriptingguy/archive/2010/03/09/hey-scripting-guy-march-9-2010.aspx

In my...

Is it running on the active replica? Have you tried re-creating the maintenance plan ?

Have you tried connecting with some other tool such as sqlcmd to see if the readonly intent is working?

sqlcmd -e -d MyDB -l 30 -M -K READONLY -Q "SELECT CAST(@@SERVERNAME...

Do you mean something like this?

DECLARE @DB_name NVARCHAR(128) = N'My_database_name';

IF EXISTS ( SELECT * FROM [sys].[dm_hadr_database_replica_states] drs

LEFT JOIN [sys].[dm_hadr_availability_replica_cluster_states] rcs ON drs.[replica_id] = rcs.replica_id

WHERE drs.database_id...

I do not have a 2012 instance to confirm this, but I think you can query dm_hadr_availability_group_states, you should be able to check the name of the primary_replica for the...

Has replica 3 already been added to the underlying WSFC?

Is replica 3 in a different subnet? If so, the listener will need to have IP addresses in all three subnets.

I...

TomThomson (7/6/2015)

---

Not quite - it's slightly wronger than before, because as well as the wrong number (which hasn't changed) it now has acquired...

Because this SSIS job accesses both SQL servers ensure that the proxy account exists on both servers has the correct permissions on both servers.

You might consider putting the logic into a stored procedure. You could restrict the permissions of the SQLServerUser login and not allow it to run arbitrary T-SQL. In the event...

Hey Reg,

I am far from an expert on Zabbix but have a couple of suggestions.

One approach would be to use a performance counter in the “SQL Server:Database Mirroring” group as...

tpsharp (12/2/2014)

---

Hi All,

This normally happens fairly shortly after the backup, and normally (but not always) after a series of these entries in the log.

SQL Server has encountered 7976 occurrence(s) of...

Not sure if this will help in your environment.

We were considering a similar architecture for a project using AlwaysOn Availability Group for High Availavility (HA)/Disaser Recovery (DR): Primary data center...