Did you wipe out the value in that column for the whole table or just one row?

No offense to you Rod, but my point exactly. No need to learn "new to you" technology to accomplish your goal, and ultimately it really won't buy you anything.

Not trying to be argumentative but by the time you set up log shipping, work out all the kinks, and then convert that server to be the online server, you...

http://www.nigelrivett.net/SQLAdmin/RecoverCorruptDatabase.html

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/18/636105.aspx

Backups would obviously be the better choice here. Hopefully the two links help.

What do you see for activity when you experience the slowness? Any blocking? (sp_who2 - look at the blkby column).

If you can get the SPID for the process that...

I used to rock climb outside of Vegas but that was before the day of cell phones (not that much before, I am not that old) and even when you...

Probably unlike most here, I don't mess with computers outside of work other than email, blogging, or writing something in Word. Sounds odd I know but.... AND, the children don't...

I am attempting to learn to play the accoustic guitar. Started a while ago but some other things took me off track for a while. Getting back now and hope...

Setting up replication to move a database server is very painful and not something I would recommend. I would however state that using backup / restore is probably the safest...

I hate to say this but you really should read the directions. There is a lot of value in what MS puts together for upgrade instructions. I have found them...

It all depends on the requirements you have for recovery and the requirements you have for downtime. With the stopping of the instance you have immediately incurred downtime and while...

Jacob,

Great article. Glad Steve put this one in the latest newsletter as I would have missed it completely. Nice, thorough job! Thanks for taking the time to put together...

I would have to say that they are unrelated or that someone accidentally wiggled the power cord in the other rack. Can't see how putting a server in a rack...

Yes, it deletes the files automatically. From BOL

"Dropping a database deletes the database from an instance of SQL Server and deletes the physical disk files used by the database. If...

Art,

Sorry to be asking questions rather than providing answers, but can you explain more? It sounds like you were physically putting your Node1 SQL Server back in the rack...