Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Posts
    17

    Unanswered: Overwriting the backup media

    Hi,

    Is there a command to overwrite the backup mdeia (I tried the NOSKIP
    option but that doesn't serve the purpose). I want the command equivalent to the checkbox in the backup window that says "Overwrite existing media".

    Thanks.
    Bujji

  2. #2
    Join Date
    Dec 2001
    Location
    Belgium
    Posts
    6
    don't know in which languagebut if you're using sqLDMO
    in VB it's like this....

    dim oBackup as new SQLDMO.Backup

    oBackup.initialize = true


    (This will put the backupdevice to 'overwrite')

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    To over write using the BACKUP command, you need to specify 'SKIP, INIT' If you want to oblitirate the backup AND any other backupsets written across the tape (stripped set) then use FORMAT. Let us know if you are still having problems.
    Paul Young
    (Knowledge is power! Get some!)

  4. #4
    Join Date
    Apr 2002
    Posts
    17
    Hi Paul,

    That seems to work.
    Thanks a lot.
    Bujji

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •