what does the backup log init do?

• vpmaciel

  Old Hand

  Points: 367

  More actions

  January 27, 2023 at 3:59 am

  #4142214

  what does the backup log init do?

  • This topic was modified 1 year, 10 months ago by  vpmaciel.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  January 27, 2023 at 11:04 am

  #4142366

  INIT

  Specifies that all backup sets should be overwritten, but preserves the media header. If INIT is specified, any existing backup set on that device is overwritten, if conditions permit. By default, BACKUP checks for the following conditions and does not overwrite the backup media if either condition exists:

  Any backup set has not yet expired. For more information, see the EXPIREDATE and RETAINDAYS options.

  The backup set name given in the BACKUP statement, if provided, does not match the name on the backup media. For more information, see the NAME option, earlier in this section.

  https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver16

• January 27, 2023 at 12:19 pm

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736188

  More actions

  January 27, 2023 at 5:18 pm

  #4142520

  This essentially initializes the file so that only this backup is written to this file.

• Jeff Moden

  SSC Guru

  Points: 1004339

  More actions

  January 27, 2023 at 7:11 pm

  #4142550

  vpmaciel wrote:

  what does the backup log init do?

  It compels me to point out that folks should read the documentation.  😀 Here's the link...

  https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?#-noinit--init-

   

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)