1. On the subscription page for the failing report, what's the status of it?. This will help to find out what went wrong.

2. Double-check the schedule. Sometimes RS uses a...

Autoshrink is very costly in terms of resources and can cause a lot of locking issues, not only on the distribution DB but on all others.

My personal preference is to...

I had the same problem where I had to backup a prod. DB 4 times a day, and at the end of every day the network guys backed up the...

I tried installing the Sample Printer Delivery Extension from RS, and did not worked the first time. But supposedly works, creating a new export...

If you see the status of the job marked as "Failed", then check the detail log of the package.

If the package did not run at all, open it and check...

The use of Tempdb depends on a lot of things: how heavely cursor, sorts, on-the-fly agregations are used, rollups, etc.  Also Tempdb is shared with all DB's and users, so...

Thank you all. I was able to transfer the log, but now the new week came up, and the cube had to be fully-reprocess (as every week).

But this time, the...

I migrated the AS repository to SQL too, but the log is still on the jet engine.

1. How do you moved the log table to SQL?

2. How do you...

Check the path for the default Data and Log files in your production server. I'm not sure where RS tries to create its databases, but I assume they should be on...

You're correct Scott; this only exports a Structured file. My mistake, sorry for the waste of time.

But also thanks to Mike for his help.

Cesar

Here's my modified copy; I changed it so it only displays the command to do the export, but you can comment out the line that executes it.

Change the destination folder...

There is a script called sp__SaveDTS, that scans sysdtspackages, and creates a call to export that package to a VB file. Once you have all the packages in text format,...