If I wanted this to email me also when the change was made, how would I do that?

Thank you!

I didn’t

Thank you for your reply. The compression is set to 0 so it is not enabled.

Thank you. I'll give uninstalling a try. I did install 2.0 and it didn't fix.

Yes, I have tried that but it says 4 is already a part of this operating system and will not install.

I am receiving these as well. Any idea?

Thank you! I was hoping I wouldn't have to restart but after reading, it appears you do. It was nice in 2012, you could change the default location...

SQLSERVER SP2 Issues:

1. Pushed SP2 to All of our 2012 AlwaysOn SQL Clusters via SCCM

2. One cluster failed to start SQLSERVER Services and Agent

a. Error: Cannot...

AlwaysOn: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required.

2015-11-22 20:16:37.08 spid18s...

It is 'Synchronous Commit'. Seems like everything is working as expected. It just fails over to DR and particular server, when failing over to DR give the following...

Thank you! There is 8GB of memory allocated to the server.

sa

This fixed the issue:

ALTER DATABASE 'DATBASE NAME' SET OFFLINE WITH ROLLBACK IMMEDIATE

ALTER DATABASE 'DATBASE NAME' SET ONLINE WITH ROLLBACK IMMEDIATE

Shelley

thank you so much!

Shelley

I'm apologize for the continued questions. But first time handling a job like this.

It works on the Primary AG group. On the Secondary, when the job runs it updates...