OK, I will doublecheck whether the logs were purged (if possible).

As far as I'm aware the system was up at the time.

 

OK we have determined the change in CE was the culprit.

However I got one  question  I can't find a satifactionary answer to.

Why was the logic of...

no the reason I couldn't explain yesterday was that there was barely enough time for me to just make the quick post.

Apperantly the team that is responsible for...

The "backup compression default" setting was 0.
I set it to 1.
Backup succeeded but file size still "unexplainably" large.

Thanks

I've solved it by making a duplicate of the requested report with the filters they wanted.

Yeah, I'm considering this as well, but I has nobody before me noticed this, as far as the documentation goes this query was created somewhere in 2007 and last changed...

Indeed is this a test or homework, and what have you tried,cause the answer seems simple to me.

Also 2 columns, why only 2 columns and what values do you want...

Ok I got a few questions

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'xyZ@gmail.com',

...

OK People thank you all for the answers

Sorry I couldn't be more specific,but yeah this is al internal working and I'm already working on the skin of my teeth.

The subject...

OK I'll try to summarise

The company I work for produces a certain type of machinery used from factories to common households around the world.

The database is where data being kept...

ChrisM@Work (11/3/2015)

---

Resender (11/3/2015)

---

In the meantime 123883 tables (yes 30 new tables got added) the total recordcount is

89,372,968,620

I wish I knew but I'm frequently...