how are they taking backups, have they indicated this?

Its not clear what you need, do you want detail of all filegroups or just the default filegroup.

SQL-DBA-01 (12/4/2014)

---

I found it pretty interesting. I checked the size of a database, before implementing database compression across all the user tables in a database. And Post implementation of...

you're attempting to set the sql data directory to a non clustered drive by the look of it, could you post a screen shot of this section of the installer

Do you even have tempdb contention?

Rather than just blindly following...

fileshare witnesses are mainly for geographically dispersed clusters, i find them flexible enough even for same site clusters. Of course where possible i want to use MNS only

don't bother with a disk witness and use a fileshare witness, this can be placed on a well connected peer server or even a domain controller.

SP1 is the minimum req for 2008 R2, there is no SP4 that i can...

plamannkathy (12/2/2014)

---

Hi All

I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domain\user.

I...

No, see my post above for details of the quorum

Instead of disk witness use a fileshare witness 😉

I feel your pain i've been there before....

for sql server 2008, a principal mirror database can have only one partner.

You may have multiple principal databases on server A and have one mirrored to server B and another...

Check...