The SQL server service resource itself usually has a dependency on any disks that are part of the instance

hdctest (4/2/2015)

---

Hello,

I have a SQL cluster and the Witness disk status shows as online but the passive node shows a "cluster event" that the passive node failed to form a...

Thinky Night (4/7/2015)

---

Hi All,

Why do I leave my DB in Restoring State after attaching to the instance? Could not this fire a redo activity on Transaction Log?

Or, How does sql...

Yes exactly that. The FCI will behave as usual.

If the FCI is unavailable then failover...

if you have one node down for maintenance you dont need to do anything

Correct. There would of course...

Really looks more like this to be honest

Microsoft do detail FCIs within AlwaysOn groups, check the following link

https://msdn.microsoft.com/en-us/library/ff878487.aspx#FciArLimitations

Also check my article at this link

http://www.sqlservercentral.com/articles/FCI/92196/[/url]

Scripting the logins is an easy task there are unlimited scripts around. You can also script any jobs from msdb too, you'll likely find many scripts for this too.

what port number have you selected?

To see a list of processes listening on the server use the following

netstat -abno -p TCP

This is the last thing you should do and you'd be well advised to avoid...

I use my own script which works out the day of the week and performs a lightweight physical_only check at peak times and a full check at least once a...

Arjun SreeVastsva (4/1/2015)

---

hi,

my database transactionlog is full I am getting below error while shrinking and also my secondary database went to not synchronising mode/suspect mode .

Msg 9002, Level 17, State...

if the index is a PK constraint the Create date is on sys.objects

Have you stopped all connections to the database to allow the decryption to complete?

Do you mean the cluster...