I am really disappointed that the discussion has been focused whether database backup and the integrity of the backup files are the responsibility of DBA, instead of how the script...

"the financially constrained defence sector."

I did not know such exists. Which country are you from? This must be a state secret. 🙂

I really don't recognize the situiation that a...

This all depends on what the Auditors say. In most ITIL and SOX/JSOX shops restoring a server to the state of the last backup cycly would be the systems...

SanDroid

Thanks for your comments. However the way enterprises organize their IT as you described is definitively not my experience. It seems that those enterprises come to a conclusion that its...

Hi Bill,

I am glad that you found the script useful.

It is planned to have a third level, database level, that can be excluded from verification or have different restore path.

One...

Hi,

Thanks for response.

I had some problem with the code submit and repost it afterwards did no good. I could send you the script if you could tel me your...

I think you missunderstand the MERGE query in SQL2008. MERGE is a shortcut for performing insert, update, or delete operations on a target table based on the results of a...