• Also with respect, I was not criticising the SQL command but, rather, pointing to the question having more than one correct answer.

    It is debatable if moving your database files (including the Backup folder) away from the C: system drive is "misconfiguration".

    Not changing the inane Microsoft default backup directory is more debatable - for the ones not brave enough to change the registry by hand, Phil Phactor has a 2 Kms DMO script and Vince Jacoboni one in Perl - see http://www.simple-talk.com/community/blogs/philfactor/archive/2007/03/22/21152.aspx.

    I prefer to NEVER rely on default configured letters... but, then again, that was just a QOTD which IMHO it has more than one correct answer or requires more qualifying conditions.