Better late than never...

I had the need for this information myself.

"How to Move the BizTalk Server Databases"

http://msdn.microsoft.com/en-us/library/aa547833(v=bts.20).aspx

That article looks like it's giving me part of the solution, but there are some things regarding scheduling and file retention I'm still going to have to figure it out....

I'll take a look at the article, thanks. There are several sp_%Backup% stored procs in the Mgmt db, so I want to make sure I use the right ones...

From

http://support.microsoft.com/kb/952555#top

"The Backup BizTalk Server SQL Server Agent job is the only supported method to back up the BizTalk Server databases. This job requires all BizTalk Server databases...

Just ran into the same issue. Cleared the hold on the log by running

sp_repldone null, null, 0, 0, 1

very badly written question and query

We have a cluster that has successfully had sp2 installed, but sp3 crashes before getting to the user validation screen with an "invalid handle" error, and it goes no further....

Microsoft Knowledge Base Article - 328306

talks about it about 3/4 of the way down

I've had an authentication/validation issue on 3 different machines at the beginning of the install, regardless of whether I use sa or a domain sysadmin/local admin account. Is this...

But in BOL,

Members of the Microsoft® SQL Server™ fixed database role db_securityadmin have permission to modify role membership and user permissions in the database.

And according to an article I found...

Thanks for that lightning-fast reply. I guess I'm barking up the wrong tree then.

The problem is that when someone with security admin status creates a NEW login,...

It's happening right now. The level of disk activity may have been coincidental, as it is low this time. The pages/sec and page faults/sec are off the chart,...

Thanks to you both for your timely replies. The cache ratio is NOT taking a hit, which is part of what puzzles me.

Steve, would physical reads be the same...

I notice that I am collecting a ridiculously large amount of data. That is the first thing I will trim down.

"Another way of doing this is to run several...

Thanks for the tip. I'll give it a shot.