What OS is the system running?

I believe so. I think that many of the commercial backup software still use SQL's APIs to backup databases. If people are backing up to tape, then the appending to...

Yes.

It is somewhat unclear how your backups are performed. Are new backup files being created every time a backup occurs, or are they appended to files? Fully understanding your backup...

What hotfix, patch or SP are you considering for the upgrade? I would say that any SP should be applied, as the workstation tools usually have upgrades in them as...

I agree with Gail. It sounds like the log backups are from a different database than the full/differential backups. If you look at the logical filenames using RESTORE FILELISTONLY, does...

Your error looks like it is having problems connecting to the default instance, not the training instance. What do the logs on the default and training instances say?

Hmmm. Not sure. I do not have as much experience with clusters as others have.

Question though - the SAN LUN that the master mdf was moved to is a cluster...

What was your process for moving the master database? Did you follow the steps in the MS KB article:

http://support.microsoft.com/kb/224071

What do you mean about the default instance on a cluster? A Windows clustered server with SQL installed on the cluster should be a named instance.

Any move of a database...

What you won't get if you set the page file on the C: drive to 0 is a memory dump in case of system failure.

This obviously sounds more like an Exchange issue than an issue with xp_sendmail. Did any of the properties of the distro group change? Can members of the distro group receive...

You don't need AWE for a 64-bit system. It is meant for 32-bit systems with the /PAE switch enabled. To clarify, did you just now set the min/max memory values,...

Do you have min and max memory settings set in SQL? If not, I would set it to make sure that you leave enough for the OS. If the max...

You are getting the error in your query in your original post because of this line:

and js.step_id = SUBSTRING( p.program_name, 72, LEN(p.program_name)-72 )

Why such a complicated comparison for the join?...