Log backups once a day, really? Whats your RPO, 24 hours, if so no need to do the log backup your nightly full will meet that expectation.

But in answer...

R is in CTP3

http://www.theregister.co.uk/2015/10/28/sql_server_2016_with_r/

Is it not just a case of adding the where clause into the script you already have

SELECT

M.[Description]

,A.*

,M.Threshold

,M.[Threshold Direction]

,CASE

WHEN M.[Threshold Direction] = '>' AND A.Value > M.Threshold THEN 'GREEN'

WHEN...

Sheep

Remove the * from the CONTAINS search, do you get the right results then?

Might be related, but has the agent account changed since setup? And if so was it done via services.msc or SQL Server Config Manager?

If services.msc, go to SQL Server...

Classifieds

Arrrrrrrrrrr

You checked that the server is right, you have permissions and that you can browse to it?

Your not using SSL at the server level are you and need to...

Generally in the past when I have done Oracle to SQL migrations, we migrate everything as NVARCHAR(MAX) (Yes I know over kill), into a staging database, then use functions...

Generally yes it would as a full backup resets the differential point.

But as these are snapshot backups using VSS unsure how they interact with the differential markers.

Would be worth doing...

Something like the following

create table #test (cola bit, colb bit, colc bit, cold bit)

insert into #test values

(1,1,1,1),

(1,null,1,1),

(1,null,null,1),

(1,null,null,null),

(1,null,null,null),

(1,null,1,null)

select * from #test

select count(*), count(cola), count(colb), count(colc), count(cold) from #test

select 'colA : '+convert(varchar,...

Big vague.

Can you elaborate more on the problem in hand?

Looks like you have a 3rd party tool also backup up the DB's as the is_snapshot flag is set to 1.

You can filter them out by adding

WHERE msdb.dbo.backupset.is_snapshot = 0

Sailor