One thing to remember os that you will have to stop/restart SQL server for this to be totally in effect. Things like @@servername and the servername in the errorlog are...

Software

    OS - Win2K3 Enterprise - SP1 (Enterprise so you can cluster later is it's that 'mission critical'

    SQL 2K Enterprise - So you can take advantage of 'extra' RAM (/3GB...

This one is a real puzzler ... I'll continue to follow it until you've got a solution or until I think of something else ...

I'm out of options except the very obvious ...

Could you post the scritp for one backup ?

Also, what is your current SQL version ?

Are you performing 'VERIFY' in the backup ? If so try removing it. If it works without the 'VERIFY' then there is a fix I know of.

By executing via QA I assume that you cut out the exact script from the Job Step. Are you backing up to a device or a file ? if a...

Can you run the backup interactively ? If this is a maintenance plan, have you tried to drop/recreate it ?

Since it's 'standard edition' I believe that it will only be able to use 2 Gb. In actuality the maximun memory used is around 1.8 Gb. If you want to use...

I too was 'taken aback' by the blanket statement Refresh your development databases nightly. Also the mention of poorly performing queries (what ever happened to the QA/Perfromance Test environment (or database) that...

I've been though a change like this before ... unfortunately there is no 'easy way' to do it ... lots of manual work ... spreadsheets and a good text editor...

EM does not 'auto refresh' so it may be another issue ...

Thanks M.S. Reddy ... good stuff ... one can always stand to learn about something 'new' every day !

Let's jump back to about 30,000 feet before you jump into profiler, stored procedures, queries and rewriting things and the 'tuning' wizards ...

Do you do regular database backups ?

If your...

That's not the first and definitely not the last ... I've seen 'foo bar' in BOL provided code since v6.0 !

A number of years ago (over 7-8) I did a solid state disk benchmark for an internet stock trading company using SCSI-II disks and solid state disks on Compaq hardware...