How to restore a 64-bit database into a 32-bit instance using a compressed backup

This one seems to baffle some, though like redirected restores, it’s something that is only tough the first few times. If you attempt to restore a 64-bit database on a 32-bit instance using a compressed backup image, you get this scary error message:

SQL2570N  A database cannot be restored on a platform that does not match the
platform on which the backup image was created.
Read the rest Continue reading »

Locks – Timeout vs. Deadlock

So questions in this area most often come from DBAs from other RDBMS’s or from developers. I’ll probably write other posts on locks, but here are the basics on deadlocks vs. timeouts.

Why we get them confused at all

Ah the wisdom that went into grouping these under a single error code with different return/reason codes.… Read the rest

Continue reading »