You can build out a script and use the "RESTORE FILELISTONLY" into a temp table to create your restore script, doing a replace on the file location, when procesisng through...

True, that's one way to force the option. But if you have an instance with multiple applications, and you want to ensure each works individually before flipping that big switch...

Using...

Nice post. I couldn’t agree more though you don’t always have to be feeder, a coffee can also go a long way as to just seeking an understanding of the...

Also on the disk front.. I wasn’t talking about moving redials. More of snapping them and presenting as copies. Something that is available in the Pure SAN system we use...

Log shipping is available with a standard failover cluster, one can even roll your own if you really wanted - all it’s doing is applying the transaction logs in no...

It would only continue to grow forever if the database were in full recovery mode, no log backups were taken and was on one of those infinity disks whose disk...

Ignore me. I thought they were updated.

Click the link that Adam out in his response then go to Code.

Everything is there for you. Download it as a zip or hook up to it with Git,...

Personally would pick Windows 2016 given the choice of OS’s. Windows 2012 is already out of mainstream support.

On top of Alex’s question, how many apps are you talking about with...

My support ticket has been closed out as a product bug, hopefully this will thus be resolved in a future CU or SP.

"[Delegation is] what you need if you want to be a Record Breaker!" - Sorry hum the theme tune in the office every time I think of Delegation - was...

Ok first thing... I've re-tested with SQL2016 SQLCMD against a clustered 2014 server. Its also not using Kerberos authentication when using the non fully-qualified computer account.

So that sucks... :doze:

Out of...

:blush:

It's when you put your head down to go to sleep after a busy day that clarity can often shine..

I may have jumped the gun with saying that it works...

I've raised this as a bug...

https://connect.microsoft.com/SQLServer/feedback/details/2840528/sql-server-2014-not-using-kerberos-authentication

EDIT

Shame I can't edit the bug as clearly I got it wrong about SQLCMD and 2016. The only thing I can do on it appears...

I’ve spun up a Windows 2016 Technical Preview 5 box just for fun, I could have used any compatible OS admittedly but I didn’t want to mess anything up I...