Monday, December 19, 2022

Rebuild index on very Large tables 1 TB table with 2K tables

Rebuild index on very Large tables 1 TB table with 2K tables


I had a situation where rebuilding the indexes ran for 1 day and filled the disk with 1.5TB.

and the log backups were taking ever and not truncating the log..what helped me to rebuild indexes and not to fill disk is below 



  • changed db to bulk recovery model from full
  • rebuild indexes 
  • changed db to FULL  recovery model  
also splitting tables of a very large db to do every nighht if we have a windows

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...