Post reply

INIT, SKIP, FORMAT Option in Backup

  • May 8, 2008 at 7:09 am

    #190311

    Could someone please explain with example what is difference between these three.

    Thanks!

  • May 8, 2008 at 7:19 am

    #812397

    nkm129 (5/8/2008)

    Could someone please explain with example what is difference between these three.

    Thanks!

    As per definition

    'SQL Server identifies backup storage media through the use of identification of the backup media as specific objects identified as media family. media family is a set of one or more backups created on a single named device. Each device is supplied with media header to identify the contents of the device. When you use the INIT option, all backup sets are overwritten, but the media header is preserved. You need to ensure that you truly do not want to keep the existing content because any existing backup set on that device is overwritten.'

    Here what is meand of 'Media header is preserved'.

    I have use following code

    BACKUP DATABASE [ACCOUNT_MANAGEMENT_V3.0] TO DISK = 'E:\BackUpTest\Data\ACCOUNT_MANAGEMENT_V3.0.bak' WITH INIT

    RESTORE HEADERONLY FROM DISK = 'E:\BackUpTest\Log\ACCOUNT_MANAGEMENT_V3.0.LOG.trn'

    AND

    BACKUP DATABASE [ACCOUNT_MANAGEMENT_V3.0] TO DISK = 'E:\BackUpTest\Data\ACCOUNT_MANAGEMENT_V3.0.bak' WITH FORMAT

    RESTORE HEADERONLY FROM DISK = 'E:\BackUpTest\Log\ACCOUNT_MANAGEMENT_V3.0.LOG.trn'

    in both case result is same ..

    I am confused with terminology used in definition. so sould someone explain in simple term what is Difference in INIT and FORMAT.

    Thanks!

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

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