Post reply

backup

  • May 17, 2008 at 4:00 am

    #191099

    Hello,

    can any one tell difference between format, noformat,

    init, noinit

  • May 17, 2008 at 9:01 am

    #816863

    INIT for overwirte.

    NOINIT for append.

    ..>>..

    MobashA

  • May 19, 2008 at 9:06 am

    #817241

    y, sure...

    init - will overwrite an existing backup file.

    noinit - will append to the existing backup file, so you can have multiple backups inside a single file.

    format/noformat -- these are tape options that tell whether to format the tape header before taking the backup. The current media will become unusable. If you have a striped tape set and you don't formate the entire set, then the rest of the set will be completely unusable. So unless you're backing up directly to tape from your command line, I wouldn't worry about it.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply