That article...

That seems to shed some light on the situation.

I haven't been here more than a few months, and I was told that previously, this archiving/text field replacement process cleared...

I've used this to kill certain client-driven processes that last longer than a certain timeout period. I'm able to grab some more detailed information via the following query

SELECT ...

I'm going to change them to compatability mode 90.

Restoring them from a .bak/.bkf file from MSDE to SQL 2005 will work? I....wasn't aware of that!

That is the idea that I was gravitating towards, GSquared. I think we have the space for it, but since the table is constantly having rows inserted into it (50,000+...

They're on the same server, so that isn't much of an issue.

Can I drop the data from the FIRST_DB_TABLE into a .csv without it blocking?

The solution for this was due to the conversations that had not completed in the queue. To resolve it, I ran the command END CONVERSATION [conversation_guid].

I was able to...

Dropping the Route is fine, but dropping the service takes an incredible amount of time. Hours and hours, and its just hanging, although not causing any blocks.

Thanks Matt, this certainly seems to be the case. I was suprised that it jumped from 4-5 hours to 12 hours just by changing the media. I suppose the trade...

I was able to run the following script, which seemed to correct my issues:

-- Delete the existing rows.

DELETE FROM msdb.dbo.syssubsystems

-- Fill the table with new rows...

The originating server for all jobs/maint plans is set to 0, so everything is conceptually on the same server.

The logs show information going up to the date when I...

I tried rolling through what you outlined, then realized it was going to be much easier to re-script the master databases. Somehow in the course of me doing this, I...

Adam Bean (3/5/2008)

---

Oh whoops, I just read again ... you're trying to restore, not move ...

Can't say I've ever had to restore the master db, I've rebuilt, but not restored....

Extremely helpful stuff, Guys, I appreciate it!

To properly back up the log (Tasks-->Back Up-->Transaction Logs), I will need to re-set the recovery model to FULL, correct? And then just...