reindexing tables

• MartinPlant

  Old Hand

  Points: 365

  More actions

  October 16, 2003 at 2:21 am

  #151950

  Hello

  I am currently re-indexing some tables on SAP but have a query with this. At present I reorg the top 15 tables on a three monthly basis but whilst doing this they seem to fill the transaction log very rapidly. Is there anyway that I can carry this out without filling the logfile so rapidly? As it was I needed to schedule in a tran log before I could log onto SAP.

• October 20, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  October 20, 2003 at 1:28 pm

  #478858

  Martin,

  What I'm doing when I'm reindexing my SAP database is the following:

  • Make a full backup
  • Truncate the log
  • Put the recovery mode on bulk logged
  • generate a script for the reindexing
  • Regulary truncate the log in between (after each big tables for the first top 10, after after the next 50, after the next 500 and after the rest of the 26.000 tables
  • Put the recovery mode back to full recovery
  • Optionally make an another full backup

  Otherwise I didn't find any other way to reduce the log.

  By a heavy usage for me a reindex every 3 month seems to be to long.

  We are doing that every month.

  Bye

  Gabor

  
  
  Bye
  Gabor