Thanks for checking, Lynn. Something definitely went awry. There is no way that the differential backup happened before the full backup, though. backupset confirms the dates.

Here's a...

I'm figuring it's either a bug or some obscure setting I'm missing.

Enterprise 64-bit edition

Version is: 9.00.3228.0

This is with a SQL Server login, not a Windows login.

Snapshot is being created from...

This is happening *again*.

Again apparently randomly.

Reboot "fixed" this last time.

It's a prodiction server so I'd rather not go that route if I can avoid it.

To update:

DBCC CHECKDB with PHYSICAL_ONLY returned no errors.

AN idle thought is that there is simply a mis-reading somewhere as this is a mirror DB, but I've had the mirror and...

You may be lucky enough to hear from Paul directly but until then, check out this article:

http://www.sqlskills.com/blogs/paul/2007/10/02/SearchEngineQA4UsingEMERGENCYModeToAccessARECOVERYPENDINGOrSUSPECTDatabase.aspx

I based this off of a script I found elsewhere (probably here)

CREATE TABLE CheckDBResults

(

RunDate datetime DEFAULT getdate(),

Error INT,

[Level] INT,

State INT,

MessageText VARCHAR(7000),

RepairLevel INT,

Status INT,

DbId INT,

ObjectId INT,

IndexId INT,...

Refactor

Split the rows up into multiple tables with a link.

The constraint isn't at issue. I'm dropping and creating constraints left and right with this shuffle. The issue is sp_tables making my life more complicated.

That'll just copy them. Take a scan through this forum. Someone just posted yesterday with pretty much the same question. You may want to check out the...

Table *very* full of data (more than 10 million rows).

SPID 2 got killed because it was blocking SPID 3. It was also a non-critical process. Killing it also...

The users are transferred over, but you need to transfer the logins. Just as you would for any other move of a DB from one server to another.

See here:...

Oh, I'm aware that there are problems. Big ones. I'm the consultant brought in to fix a system that's been in place for close to 3 years without...

Take a look at the IsNumeric() function. That should get you started.

Megan,

Make sure you're running a full backup after you switch back to full recovery model. Otherwise, you have a broken chain and won't be able to do point in...

I use it almost daily to monitor my production servers. Impact is minimal to none.