That's normal, the checkpoint and the backup log both have to write to the transaction log, hence one will block the other.

If it's happening often, check the duration of checkpoint,...

Please post new questions in a new thread. Thank you.

AndrewSQLDBA (2/24/2010)

---

Differential backups would be taken on a daily or multiple times thru the day and night to accommodate that if a failure were to happen, the database and the...

A page restore will not work here. Besides, it looks like there's more than just three pages damaged. The comment about not being able to latch a page with reason...

Too high? That's a value of 0.0000035. Why do you think that's too high and why do you think that the index isn't useful?

Density is defined as 1/(number of unique...

If you want some reading on corruption, you could start with this. http://www.sqlservercentral.com/articles/Corruption/65804/

Fatal.

You have damage to a couple of your allocation pages (specifically PFS pages). This kind of corruption is irreparable.

Take a tail-log backup (if you can), then restore your full...

However it is the only repair level allowed when the...

That isn't necessarily insufficient memory. Yes, memory may help, but you should also look at what's running and see what needs fixing/changing...

Enable traceflag 1222. That will write a deadlock graph into the error log whenever a deadlock occurs. Post it here.

Most deadlocks are a result of non-optimal code or non-optimal indexes...

12-14 GB. No more (and I'd err on the lower end of that). OS needs memory to manage memory, not good to starve it.

david.c.holley (2/23/2010)

---

I fully understand the difference between a full backup versus a differential. Given that my experience as an Admin on a SQL Server database is nil, is it easier...

Are you talking about...

Find out why it's down. All other troubleshooting steps will be based on the results of that.

since this is in the 2005 forums (and hence should be a 2005 database) SELECt state_desc from...