Might be an issue with 2016, you running the most recent CTP?

Not had chance to install and play with 2016 yet so all stabs in the dark.

Try running IE as admin to get around UAC, if that's your problem question with you sysadmins / security personnel as to weather or not UAC is a requirement for...

Something like the following

;with cte as

(

select

row_number() over (partition by t1.pid order by t1.pid, t2.flag) as RN,

t1.pid,

t1.name,

t1.amount,

t2.subnum,

t2.flag

from

t1

inner join

t2

on t1.pid = t2.pid

)

select

case when rn = 1 then pid else 0 end as...

recession

Not going to stand one out from the other, they are all good tools, they all monitor, they all do the same thing, just in different ways and allow for...

Mixed, as detailed, try them all out, they all do the same but different, they...

Take a look at

Red-Gate SQL Monitor

Idera Diagnostic Manager

Dell Spotlight on SQL Server

Dell Foglight

SQL Sentry Performance Adviser

ApexSQL Monitor

Prices vary, and will vary on bulk purchasing so prices are never usually given...

Assuming you want to create the script in SSMS on the same server where the backups are taken from, take a look at the backup tables in MSDB to dynamically...

Remove the ' from around the hex value

select * from sysjobsteps where job_id = 0xBEB303926F0CE848BA3F9858417DB773

The hex value is the GUID converted to hex and binary is passed in without quotes...

Stuart Davies (12/11/2015)

---

Desmond

Then monitor what is using TempDB and define if this is normal or not.

If not go speak to the person who is causing the issue and work with them to...

Yes defiantly looks like a double hop issue.

Check with your domain admins, that the SQL Server accounts have trusted for delegation rights and that the correct SPN's have been set...

Log growth is normal.

Is the growth rate your seeing normal, who knows.

You will need to monitor whats using TempDB to see whats causing the log growth, maybe you had a...

Gazareth (12/10/2015)

---

richardmgreen1 (12/10/2015)

---

We aren't using it for failover.

The mirrors will be snapshotted for use in reporting.

We need the data to run various reports on (that's on thr BI Edition server).

The...

Ah ok, that makes more sense.

In theory it should work, but as John has already mentioned mirroring is now a depreciated feature.

I would take a look at Log Shipping instead...