where is that stated Perry (just interested)

Brandie Tarvin (6/22/2016)

---

Quick question on the backups......

you license a server, so the number of instances do not affect it.

my understanding is that anything that comes under client tools or connectivity does not need to be licensed

put an exec in front of dbo.report_stale_open_teller_count

This is because if the execution of a stored procedure is not the only statement in the batch, you need to add an explicit...

use at your peril I guess?

Are these the commands used by hardware based backup solutions?

SQLRNNR (5/3/2016)

---

+1. Very specific question. I also...

george sibbald (4/22/2016)

---

As I have multi subnets (two) I have two IP addresses for the listener resource in the cluster, the primary online and the replica showing as offline, would...

Hi Perry, thanks for article, most useful.

I have just configured our first multi subnet AG and have a couple of questions. I note on the listener tab you have specified...

how badly are the indexes fragmented? Have you considered reorganising rather than rebuilding, it will be less intrusive, you can then at least control log growth and cancel it if...

everyone who got this right will have their point deducted. Its only fair.

is this a default instance? SSMS as a client presumes port 1433, so if it is set to some other value you need to explicitly specify it.

'meant to be' and 'have to' are two different things..............

or one different thing in this case.................:-)

only always on is going to provide all the options the op asks for with a DR secondary and a read only secondary, but complicated and expensive, log shipping will...

jasona.work (4/13/2016)

---

The downside of not having a hand in development-type stuff...

You don't know about handy things like the SSIS task "Transfer Jobs" and "Transfer Logins"...

Thankfully I came across those today,...