We are still looking for an article for SQLServerCentral on this.

jcrawf02 (12/16/2011)

---

By the way, if anyone feels so inclined, prayers and happy thoughts would be appreciated for my family today. No more info at the moment, I might share in...

wiggle, wiggle, wiggle

http://www.youtube.com/watch?v=WKxx5QC0ewc

yes

Please start a separate thread for a new question, and also post some sample data and table DDL. Your description of the problem doesn't make enough sense without an example.

The subscriber is always online.

What you want to do is send the clients to the secondary. This is a manual process. You can do it a few ways, but it...

So only one row per date?

Easy to do

if not exists

( select cut_date from test where cut_date = @cut_date

)

Insert into dbo.test

select

@cut_date,

...

Do you have automatic failover? Are you expecting people to work off the mirror while the primary one is down? If so, account for the backup and restore to fail...

What does empty mean? Does that mean you want to export the data or you want to delete all the data?

Which steps produced the error? If this comes from Configuration Manager than you may have something broken or corrupt in your installation.

Do you have encryption set? Does this apply?...

It's only Wednesday!!!!!! Feels like Friday afternoon to me

Of course

Added to the list.

I've given up on searching that way, and only search using site search, unchecking boxes.

Without seeing more sp_who output, you can't determine that the checkpoint is blocking everyone. I might recommend you get a script for the block tree, or get sp_whoisactive and use...

Bru has the right idea. Depending on the load of I/O for your files, I'd move either the log files or tempdb to reduce contention. That assumes you have I/O...