Excellent article, nice to know the info is there if I need it.

One question, did you use this on SQL 2000 replication? (yes, companies out there are still using it!)...

Nice article, I have implemented this a number of times, as much as you try and coerce your boss/cient into using/buying 64bit OS/SQL, you have to work with what is...

Much appreciated.

Rgds,

qh

Five stars for me as I find this type of article almost a "reverse engineering" concept, sometimes this can help with the understanding.

Good stuff.

qh

2500 - The Buck Rogers Era

Or to be more precise, 2419 (AD). 😉

qh

Have you checked the read/write permissions for the post migration snapshot folder?

qh

"...work with 2012 or later."

You know something we don't? 😉

qh

Good post, it has generated some good points (bgdjwoods especially) and people are asking the OP why did you not do it like this, or do it this way. ...

Dustin Tabor-299352 (3/12/2012)

---

Its sort of like an older car, yes, it might break down, and Ford or GM might not support it, but at least for now there is still...

okbangas (2/28/2012)

---

First of all, I want to thank everyone for the good feedback.

No matter if Lock Pages in Memory is enabled or not, SQL Server will attempt to release memory...

Good article for Prod DBA's trying to sort out slow running queries created by junior developers. 😉

qh

Added to the briefcase, nice insurance policy when the worst happens. :w00t:

qh

Like many "oldies" on here I use pen and paper to make daily notes, basically because I don't have really have a memory :crazy: and I like to keep track...

I created a new thread in the SQL 2008 HA section where I have to look at both primary and secondary/monitor servers to get the information I require. Check here.

Good...

Excellent article, great job.

qh