Have you tried recovering the secondary, then putting it into restricted_user mode first? (Sorry- I had a similar issue recently, but without the instances actually in front of me it's...

Yes- does this apply? http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/01/21/alwayson-availability-groups-may-be-reported-as-not-synchronizing-after-you-apply-sql2012-sp2-cu3-or-sql2012-sp2-cu4-or-sql2014-cu5.aspx

Is it an asynchronous replica?

If the SQL error log gives you the IP addresses you can find out the hostname the connection attempts are coming from by using ping -a ipaddressgoeshere

Not sure- have you tried using T SQL;

Create login [domain\user] from Windows

?

Thanks- I've had to stop messing around with that to work on something else, but I do appreciate the help, and may be able to have another try in a...

As Gail's already said, it's the DBA's job to set the max server memory. It's usually one of the post-installation steps, and the value depends on various factors including how...

Yep, that's just the default value

Thanks very much, both. I will take a look at those links.

Hi

Thanks for replying. Like this?

Check you're patched to the right level: sqlserverupdates.com

https://support.microsoft.com/en-gb/kb/2315727

You don't need a new backup- as Gila says you just need the old backup(s) again.

And this results in absolutely no error message?

What's the error message?

Steve Jones - SSC Editor (10/19/2015)

---

william-700725 (10/19/2015)

---

Steve, I think you are seriously understating the potential damage a bad manager can do.

The two worst-case scenarios are managers who actually increase divisiveness...