a DW is not designed to be a complete replica of all your data, well at least it shouldn't be anyway!

The warehouse is used for storing and presenting data to...

agent job tokens are detailed at this link

https://msdn.microsoft.com/en-us/library/ms175575.aspx

the workaround is not supported by MS, standalone features cannot be added to existing clustered features.

This link https://msdn.microsoft.com/en-us/library/bb630402.aspx details the following

MSDN - Host a Report Server Database in a SQL...

sqlserverDBA2016 (11/5/2016)

---

I have 40 databases on a single sql server instance

I wanna move them to 2 new data and log directories

Using backup and restore but would like to keep the...

VMware?

Hyper-V?

How many virtual NICS are exposed to the cluster nodes?

Have you run a cluster validation?

szejiekoh (11/5/2016)

---

Hi Perry,

Good to hear from you! Thanks for replying.!

q1) Can you elaborate further ? Even if msdb has system information embedded within, what is the problem of taking a...

is this a virtual machine?

No!

do not do this, MSDB like...

sqld-_-ba (11/2/2016)

---

Our primary single OLTP SQL VM is 'dedicated' to one of the hosts, i.e. no other VMs are allowed to run on it, cos it requires all 16 cores...

oscarDBA (11/2/2016)

---

Hi,

I've been SQL Server DBA for about a year of 5 small databases.

I've read about high availability and I'd like to practice with this feature.

I understand that no one...

check the step history carefully, although theyre marked as successful there'll likely be a message indicating logs cannot be applied

service packs may be uninstalled so no real need for worry there.

For the SP install and the inplace upgrade perform these in your test environments first to be sure...

Probably had a Eureka moment after reading the replies 😀

database mail requires the sql server agent, which express does not have

sql_2005_fan (10/25/2016)

---

Hi,

We are planning for a sql server disaster recovery plan with Always on availabilty groups for sql server 2016.

Can we have a sql server failover cluster with the shared...