luisalfonso70 (8/12/2016)

---

Hello, I've read about the options for failover cluster on SQL Server 2016, so if I want to have high availability with my SQL Server I've to:

...

VastSQL (8/2/2016)

---

Thanks Perry.

As...

JP10 (8/3/2016)

---

Question is it best practice to let new upgraded node run in PROD for couple days then once there are no errors we can upgrade the other node and...

You're welcome

ODBC table links are created via linked table manager, google will detail exactly how to connect

mikaeru (8/1/2016)

---

Good afternoon,

I'm currently trying to set up Always on 2012 between 2 different data-center's using of course 2 different subnets, i have few questions;

Situation: we got 3 servers under...

sql server 2005 and sql server 2016 have very different OS support, so they wont reside on the same server.

If you have a sql 2005 instance on one server and...

The passwords only need to be updated once and on the active node

Also bear in mind, if the principal and mirror then become disconnected too, the principal will go offline.

This is mainly used for internal operations and things like linked servers , etc.

I have done in the past, if you're really uncomfortable get a maintenance window arranged

Run the drop server then add server they should run instantaneously

Then you'll have a cluster with no failover capability!

I'd still like to know the full spec of each VM (I.e. Number of vcpus, vnics, vdisks, etc)?

krypto69 (8/2/2016)

---

Without the TF 1117 the splitting of the tempdb into multiple files is likely to be an utterly useless exercise as the load will more or less end up...

ThomasRushton (8/2/2016)

---

Terje Hermanseter (8/2/2016)

---

You can check the status of your restore operation with the dynamic managment view sys.dm_exec_requests

To view only RESTORE/BACKUP operations you can include a where clause:

SELECT *

FROM sys.dm_exec_requests

WHERE...