Do you need to move the installation, or just the databases?

That looks pretty good to me.

I like to also compare row counts before and after to prove no records were lost as part of the upgrade process.

I agree with gmamata7,...

My take is that it's about least privilege- local system and domain admin are high level accounts that have rights beyond a standard AD account.

If you have a vulnerability in...

Sorry, to clarify- you can view the x64 DTS packages on your server from a 32 bit client (if you install the management tools).

My recommendation from experience is to install the management tools on a client PC (or 32 bit server). You shouldn't need to "manage" the DTS packages from the server itself,...

From my experience, you are better off opening each DTS package and saving them to the new SQL 2008 server individually (rather than importing and exporting).

We found that with exporting...

Vishal Singh (6/16/2010)

Running the profiler in the first place is...

Start by running a profiler trace and perfmon session.

There are many articles on this siteif you search for them...

I'm guessing that you don't have log shipping setup then. (In the database properties, I can see backup details, maintenence plan information and under that log shipping- with a 'details'...

Apologies, I just re-read your post and noticed you already detached the databases. This might be the issue however, if you detatched them without disabling log shipping (I am assuming...

Have you disabled log shipping (you can check if it is enabled by right clicking the database -> Properties in the general tab click 'details').

It's in RTM. Here is the link:

http://www.microsoft.com/Presspass/press/2010/apr10/SQL08RTMPR.mspx

I usually wait till SP1 is released, but this is a bit of an old fashioned mentality as Microsoft release patches more...

You should check the windows logs on the server also.

you could try and delete a .bak file in the subdirectory using xp_cmdshell (if enabled). The error might point you in...

It's totally possible- I tested it successfully!

You're better off using Database Mail with the code Mohammed suggested above

Easier to configure than trying to debug your VBscript...