I have thoroughly considered your request and I DO NOT AGREE or DIS-AGREE with
it as of this email… It did raise the graying hairs of experience on the
back of my head as a potential benefit to future problem issue. So please hear
me out, by reading the below.
I respectfully, request that you consider what you are asking here in light of
the fact that the backup is a function of the MS database version or some other
software such as Quest LiteSpeed for SQL Server. I am not sure, that Quest is
where this must be asked. I believe your suggestion, just placed on the table
and then looked upon, has merit. However, since I am doing several backup and
restores as part of release builds, I am having a hard time separating the
software option you asked for with the responsibility of the user.
You sir are well versed in this process, but a newbie to SQL Server and Quest
Toad-SS or Quest LiteSpeed, might make a mistake and if that does happen then
there will be issues of liability and finger pointing the Quest deviated away
from Microsoft best practices in this very specific area.
Personally, I take your suggestion/instruct ions seriously and I am not
diminishing the need, I am just worried about some un-intended consequences of
your request in the wrong hands.
I teach all Product Support and operations folks to not only enter in the
correct info, but to printout and validate the backup/restore script so as to
submit same and part of their operations documentation. This may sound like an
overkill, but since the default action or S.O.P.(rocess) currently allows for
the restore SQL Statement to be reviewed only if the user selects the ‘SQL
Script’, then I respectfully request that TOAD-SS also do a Quest
LiteSpeed 5.2 does here on backups and that is to show this final SQL Script as
part of a validation box.
At the end of the day, this is not my call. However, I have written the above in
order to stir your thoughts as well as others so as to see if there are really
any true issues with this request.
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary