Can you restart the distributed transaction coordinator instead of rebooting? If the queries don't modify any local data, that might kill them without having to reboot.

Can you take the database offline at all?

If so, take it offline, move the log files, and run Create Database For Attach_Rebuild_Log, and see what that does.

Edit: Don't have to...

Have you tried removing and re-creating the file?

The easy way to do it is to re-install in the location where you want the binaries.

Most of what matters in SQL Server isn't in the instance data anyway. ...

I guess I'm not clear on what you mean by "the instance data". Do you mean the system databases for the instances? Or something else?

Try this in the relevant database:

SELECT *

FROM sys.fulltext_catalogs

Nadrek (10/18/2011)

---

GSquared (10/17/2011)

I'd be more inclined to go by average deviation in size, not just by average size, but average size is probably good enough. I'm lazy about it...

Evil Kraig F (10/18/2011)

---

Aye, fight and you may die, run, and you'll live... at least a while. And dying in your beds, many years from now, would you be...

It can. Mainly in terms of making the transaction log hold onto data longer and the usual effects from that.

Well, this year I got to miss PASS because I spent the last two weeks migrating some database servers from one datacenter to another three times.

Tonight, I'm again up all...

Nadrek (10/14/2011)

---

GSquared (10/13/2011)

---

Another thing to keep in mind is that varchar storage takes more bytes than char storage, since it has to also store the length. Plus, because of...

You're welcome.

You're welcome.

Check out "DBCC CHECKDB" online. That should do what you need.

7zip has a -p switch that allows you assign a password to an archive.

Here's a page with samples: http://www.dotnetperls.com/7-zip-examples

Ctrl-F "password" to find the one you need. It's a ways...