cpathidba (3/2/2015)

---

If you want just start the server then you need master database is enough.

if you want more services like agent services,db mail services etc. then you need model and...

You must remove the primary database from any log backup maintenance plans or jobs. The log shipping plan will create a dedicated agent job that will schedule the transaction log...

do you have log backups running on this database

The secondary database must be restored with either NORECOVERY or STANDBY.

what is the recovery model set to on this database

A backup log command on a secondary replica will truncate the log as necessary on the Primary. This link details the following

SQL Server Books Online

---

To back up a secondary database,...

depends on your config, generally 2008R2 is not as tolerant as windows 2012

with minimal startup just master, other than that master and model, tempdb is re created if it doesn't exist. SQL Server Agent wont start if msdb is missing

salnasi (2/27/2015)

---

Windows Server 2012R2 there is something called the dynamic Quorum. When this option is enabled, the cluster dynamically manages the vote assignment to nodes, based on the...

can you list out the SPNs and post details of them, obfuscate any names first obviously

taking dtc offline does not affect the cluster.

As for the disk witness it depends on your config.

If you have only 2 nodes in the cluster and a disk witness, you...

This is the time to iron these things out see which way works best for your scenario

POC = Proof Of Concept

You still haven't answered my question, did you run any scripts as part of the Readonly routing setup, if so please post details.

If you didn't, then you have no RO...

slab and trim are more to do with the storage that sits underneath the volume, seems to be a storage system configuration issue