Hi. Thanks for posting this script for checking database size.

Could you suggestion? how can get all target DB server database size in one single by using your script? if required...

I have searched and found this link https://support.microsoft.com/en-in/kb/2879704"> https://support.microsoft.com/en-in/kb/2879704 .

this link suggested as below

1. install .Net 4.5 framework on top of windows 2008 R2. which was installed...

Please help, how windows authentication to connect the web application?

In my case, there are two different server and both the servers are member of same domain group.

SQL 2012 DB server...

Hi Lowell,

1. I turned on SQL browser service then SQL instance does not connect without custom port. it would connect after mentioned port.

2. Does it require and mandatory to create...

Hi Willem G.. Thank you so much for sharing backup report script and monitoring across all remote database in single email report.

1. Full backup configured by thru SQL maintenance...

Hi Satya.. this is excellent script for sharing..

How can I add linked server name in this script for getting backup report in one single format.

I have created linked server, Name...

As below code working and fetching data from remote server but Remote server database name not display..

SELECT DB.name AS DatabaseName

,MAX(DB.recovery_model_desc) AS RecModel

...

Hi Perry thank you..

Let me explain my current multi subnet failover cluster setup..

1. sessions are synchronous mode (both local site 2 Nodes and DR site 1 Node - AG databases)

All...

Resolved issues.. listener created successfully after giving proper permission in AD side.

this Listener object must be added in cluster computer object security permissions with full rights

Thanks

Thanks for your valuable reply..

In AD team shows to me, that Pre-staged Listener name object and domain account having FULL Control defined in AD level even same problem coming.

Pl. guide...

I tried again manually move to cluster resource to DR datacenter in another subnet IP.

Select Cluster name-> select More action-> select Move Core Cluster Resource -> Select Node - choose...

I have checked manually that second IPs. it is not bring online.

1. First IP to bring offline then cluster name and first IP become a offline.

2. Then bring second IP...

Attached screen shots Cluster core resource

Where have you created the cluster subnet IP, which node?

I have created cluster name in Primary datacenter servers in first node. And adding secondary datacenter different subnet IP while...

This is two IPs configured in cluster name..

As per this AO cluster setting not using shared disk SAN, NAS etc and Not configured quorum witness.

Due to 3 nodes participates....