Thank you SSC Journeyman,

I like your use of xp_cmdshell.

SSComitted,

Thanks for the feedback. No doubt I am reinventing something here. It seems to be an effective method of me learning the inner workings of backups rather than just executing...

Mr or Mrs. 500,

I think Compression is definitely appropriate for the scope of this script. It is a default setting we usually have on our installations, but I think it...

Forum Newbie,

Links with downloads of the scripts should be available at the bottom of the article under the Resources section.

SSC-Enthusiastic,

I believe that is a good question. Retrieving the backups from virtual tape can take anywhere from 30 minutes to 2 days depending on the size. So in situations where...