differentials question - can i skip a full backup?

Hi,
I have a SqlExpress app and would like to start using differential
backups (we currently always use full backups) for our auto-backup
utility. The problem is that the users can create their own backups
(always full). My auto-backup utility will not use these files. I
control the auto-backups and hide them from the user.
Can I somehow tell SqlExpress to ignore any user-created backups and
reference my differentials off MY full backups?
thanks very much!
Deanna
That's GREAT news. The user backs up via the application, so assuming
there's a SQLDMO option for COPY_ONLY I am home free. I'm off to
research. If there's NOT and you have another way to programmatically
cause the COPY_ONLY option please let me know!
thanks so much!
Deanna
|||Tibor,
Thanks so much. I was just reading about SMO this morning (we JUST
moved to 2005 and I haven't caught up). I do NOT see the COPY_ONLY
exposed in SMO though. Nor do I see an .ExecuteImmediate on SMO. I
guess I should stick with DMO and use the .ExecuteImmediate. If anyone
knows a way to accomplish this with SMO please let me know. I'd prefer
to dump DMO.
Thanks for all the help!
Deanna