Firstly, don't use administrative shares for file\folder access, create a new share at the appropriate folder level and ensure you set the following for the account the SQL Server agent...

another user encountered this previously and the recommendation from Microsoft was the following (in order from highest to lowest priority)

Public

Private

iSCSI

Personally I have always used the following

Public

iSCSI

Private

The Public network is usually...

the first item to tackle is why the network connection is lost. Also, the implementation of an extra network may help to maintain connectivity between sites.

It's the Database!!! (10/18/2013)

---

Thank you Perry, I also have MS involved and they could not get the DB switched over to NONE either. I will email results once I have...

what you're seeing there is just the AlwaysOn listener resource. In the same group\application you should have a Virtual IP and networkname, this network name will be registered in AD...

changing the VNN is fairly easy, just edit the VNN resource in failover cluster manager. Once renamed take the resource offline which will take the instance offline too. Restart the...

logicinside22 (10/17/2013)

---

Hi Guys

Looking for Steps to perfrom for shrinking Data and log files for Mirrored Database. Can any one give insturction step by step . would...

The reason for this is because of what happens when a failover of a virtual name resource occurs under Windows Server Failover clusters.

The virtual network name is unregistered in DNS...

Dont bother with SQL agent or anything else, just use the following all within the same session

[Code="sql"]USE (mydatabase)

GO

ALTER DATABASE (mydatabase)

SET SINGLE_USER with rollback immediate;

GO

ALTER DATABASE (mydatabase) SET CONTAINMENT = NONE

GO

ALTER...

You should run the sp_configure last not first.

If you want to disable containment at the instance level then for each database that has containment enabled do the following

alter database...