Jeff Moden (8/15/2008)

---

I'm such a dummy... to do this in almost a single click, I just need to turn of the SQL Server Agent and turn it back on when...

Lowell (3/4/2014)

---

i don't think you really need the database at all.

I'd create a job script for the client, nad ask the client to add a job or two , that...

sqlbuddy123 (3/4/2014)

---

I think you can scramble the CC data and restore the DB. The company that I work has a similar scrambling process and a special team takes care of...

Hi,

Many thanks for all your replies and yes I do agree that running CHECKDB on a dummy database is not the same as running it in production and my results...

Grant Fritchey (2/25/2014)

---

The one suggestion I can offer to cut the time is to just do a statistics update, not an index rebuild. You actually don't even have to do...

Cheers David!

Rgds,

qh

As an addendum: I have suggested that say one day before the migration we could prep the target instance as much as we could logins/ssis/etc, then restore a full...

Excellent suggestions many thanks, I suppose it does come down to how our ScaryDBA friend puts it: FAST or RIGHT? :ermm:

Cheers, god bless SSC! 😎

qh

SQL2008R2? Are you in correct forum?

Rgds,

qh

Muthukkumaran/Gail,

Much appreciated, glad I asked, it did seem far too simple in my head! :crazy:

Now I'm looking for a version of sql server where a database in recovery can still...

DTS Packages

Identify all packages to migrate

Manually "Save As" packages to NEW server

Update any affected pointers

Scheduled Jobs

Identify all Jobs to be migrated

Copy jobs to New Server

DO NOT COPY JOBS THAT RUN...

Grant Fritchey (2/11/2014)

---

Back when I was doing 2005 upgrades, I ran it against lots of production systems with no issues. Does it add to the load on the server? Absolutely....

Can you not rename your DR Clustered environment to a different name?

qh

Hi Keith thanks for the reply and link. A new trace file will need to be created. I am not envisaging many gotchas as it is a 2005...

Great article, all newbie (and the seasoned pros!) should read, digest and follow the steps.

qh