From SQLMag – I have a 30GB database, and I use the Full recovery model. Whenever I use Database Consistency Checker (DBCC) DBREINDEX to periodically reindex certain large tables, I change the recovery model to Bulk_Logged, then return it to Full after the reindexing is complete. I expected that thi
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help