Sending positive thoughts and hope you are on the mend soon! Thanks for all you do for the SQL community!

Hey Gary,

Thanks for reading.

You could change the first part of the where clause so that it's looking for databases without a last full backup within 7 days and the differential...

Hey Keith - are you being blocked from getting to the PowerShell Gallery? Perhaps a policy if you're on a work network?

Well things are a little different currently as I'm working from home full time while we battle this virus. Currently I'm getting up, making coffee and then reading (fiction usually)...

We have logging turned on for some of the packages but that writes to a text...

Brian Knight (6/2/2014)

---

You may want to consider applying the BI xPress SSIS auditing framework (community edition is free) so you can track the failure a little cleaner than a text...

Thanks for your reply.

Yes Cozyroc is licensed on the machine and it's not just packages with CozyRoc that are not showing the errors.

SQLKnowItAll (3/4/2014)

---

jpomfret7 (7/13/2011)

---

Peter Maloof (7/5/2011)

---

David:

I have to disagree that a phone book is an unclustered index.

Unless I'm mistaken, the white pages contain data physically sorted by

last name, first name and...

Using a function in the where clause can change a seek to a scan:

select checkcolumn, LongColumn

from test

where round(checkcolumn,0) = 7

Note: checkcolumn is an int and there is a suitable index...

I hadn't thought of roles, thanks for the suggestion.

Awesome, thanks for your help! 🙂

Only trouble is will the SQL Task wait for the backup to complete...

Double checked the linked server and that all looks good.

What do you mean by this?

Thanks for your help

That is weird, my only suggestion would be to add some logging to the SSIS package so you can tell where it is getting stuck. Maybe you have it so...

This database does get replicated to other sources, what impact could this have on the vlfs in the logfile? Would transactions take longer to replicate due to it waiting...