try moving the backup into another folder on the c:\.

This is a great article, it's amazing what you can forget over time.... 🙂

This MSDN article explains it:

http://msdn.microsoft.com/en-gb/library/bb934049.aspx

The job history cycles, ensure that the retention period is high enough and rows per job is set. This can be tricky if you have loads of jobs on...

You could try using a WQL query - something like the following:

This...

GilaMonster (3/28/2013)

None. Shrinking a DB doesn't affect the stats so there's no...

Isn't sysprocess the system table behind sp_who2?

Take a ganders at sp_whoisactive - we use this at my company and shows lots of relevant info 🙂 - safe to use in...

select * from table nolock

This will simply alias the table as nolock so when you join to another table, in the ON predicate you can refer to the table as...

If you do shrink it then yes rebuilding the indexes and updating stats is a must, but remember it will cause all your queries to recompile. I'm not sure...

The only log that gets updated when this error happens is the ReportServerService_xxxxxxxxxxx log

This is what the message looks like:

There doesn't appear to be anything in the log with verbose logging enabled either...

Just found this post which looks like it answers my questions 🙂

http://www.sqlservercentral.com/articles/powershell/65196/

Nice article 🙂

These posts are great for setting things like colours, fonts etc but is it possible to set options to get the report to scale to fit different screens? (i.e removing...

does select @@trancount or dbcc opentran work in tempdb?