Coozie (8/31/2010)
I agree. I'm more comfortable with using jobs to create backups and then back those up to tape because it just makes my life easier.I've never did any homework on how it's done live, but I believe it is backed up from a stack. I just thought that meant it was somehow related to backing up the mdb, but now I realize how dumb that sounds. I guess it's done with smoke and mirrors, or realistically, stored procs.
Thank you all for all your help and feedback.
Mark
Makes your life easier until you can't restore when something blows up 🙂 I would do a DR exercise every now and again to protect you albeit I am sure it will all be fine.