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