Best way to determine to Clustered index keys

• Ricky Valencia

  SSCommitted

  Points: 1907

  More actions

  February 8, 2017 at 12:38 am

  #1927250

  Hi Robin,

  No. Bulk logged recovery model will not work in always on. The database must be in Full recovery model before it can participate in an AAG.

  --Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)
  https://msdn.microsoft.com/en-us/library/ff878487.aspx

• Robin35

  SSCertifiable

  Points: 6471

  More actions

  February 8, 2017 at 5:05 pm

  #1927419

  Ricky Valencia - Wednesday, February 8, 2017 12:38 AM

  Hi Robin,

  No. Bulk logged recovery model will not work in always on. The database must be in Full recovery model before it can participate in an AAG.

  --Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)
  https://msdn.microsoft.com/en-us/library/ff878487.aspx

  Thanks Ricky.

• February 9, 2017 at 10:24 pm

  This was removed by the editor as SPAM

• Jeff Moden

  SSC Guru

  Points: 1004339

  More actions

  February 11, 2017 at 9:59 am

  #1927946

  JasonClark - Thursday, February 9, 2017 10:24 PM

  Bulk recovery does not able to capture changes on a transaction by transactions due to which risk of data loss chances are there.
  

  I'm not sure what you're talking about.  Under "normal" circumstances (like no AG, for example), If no minimally logged transactions are used, there is no difference between the BULK LOGGED Recover Model and the FULL Recovery Model.  The log file can be used for Point-In-Time recovery.

  The difference occurs in BULK LOGGED if ANY minimally logged transaction takes place.  In that case, the backup file is marked as having had a minimally logged operation and, for restores, either the whole file must be restored or you have to stop the restore at the point in time prior to the start of this file.  If you do use the whole file, then any log file restored after that that does NOT have a minimally logged transaction in it can be targeted for a point in time stop of the restore.

  --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)