The transaction does not exist to call rollback on (4046253)

Receiving "The transaction does not exist to call rollback on" errors on a job

The Catalog Database is getting or is full

You can do one or both of two things:

Upgrade to SQL express 2008

• Go to http://www.microsoft.com/sqlserver/en/us/editions/express.aspx. Download and install SQL Express 2008.

Remove unneeded DB records

You need to do it in SQL management studio connected to SQL running Catalog DB. Can take about 5 minutes

1. Open Management studio

2. Expand Databases. You should see Catalog here.

3. press New Query on the toolbar

4. In new window paste

-- script begin

USE Catalog

DELETE Queues

DBCC SHRINKDATABASE (Catalog)

-- script end

5. Run (Exclamation point on the toolbar).

SQL Management Studio

• (2005) - http://www.microsoft.com/download/en/details.aspx?id=8961
• (2008) - http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7593