Mentioned in my initial posting:

I capture this error...

Thanks, but this link does not apply to sql 2008 (whick I'm on). Besides, the exact same backup command works fine on its own (outside the internal-activation...

Microsoft have kindly provided me with the following query for obtaining those reports with the largest size contribution to ReportServerTempDB:

--Reports that are largest contributors to ReportServerTempDB size through tables Segment,...

Thanks, good to know.

Michael Valentine Jones (10/5/2011)

---

According to SQL Server 2008 R2 Books Online topic "Report Server Database":

http://technet.microsoft.com/en-us/library/ms156016.aspx

"...

Report Server Temporary Database

Each report server database uses a related temporary database to store session...

Thanks for responding.

I am also thinking of opening a case with Microsoft on this because it doesn't seem right.

There seems to be no pruning process on this table, shipping...

Here is my code for this (attached).

Run script "CurrentlyRunningJobs_GetTotalDurationCompletedSteps.sql.txt" in a DBA-owned database on the instance in question, say UTILDB, to create stored procedure [CurrentlyRunningJobs_GetTotalDurationCompletedSteps].

Then run script "CurrentlyRunningJobs.sql.txt" to get...

Thanks for sharing; I tried it and, indeed, your...

Correct.

Run this:

--http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx#EX1AE

SELECT

R1.session_id

, ...

There are cases where a blocking session may not fall under either of these criteria:

...

WHERE r.blocking_session_id <> 0

OR EXISTS

...

Kwisatz78 (9/30/2011)

---

Ok I think I have found some information stating that PLE just affects the buffer pool. However I now have a follow up question on this. If...

Instead of killing the sessions one by one, try doing this:

ALTER DATABASE [dbname] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE;

-- this will kill all connections to the db, except for...

Yes! 😉

The history log of the failure is not very helpful:

Message

Executed as user: xxxx\xxxx. ..._Content', file 'xxxx' on file 1. [SQLSTATE 01000] (Message 4035) Processed 68 pages for...