Advertisement

06.06.2006 at 08:41AM PDT, ID: 21876485
[x]
Attachment Details

How are log files effected by reindexing?

Asked by MrBean in Databases Miscellaneous

Tags: file, reindex, databases

Hello,

I'm curious to as how a log file who's recovery mode is set to SIMPLE is effected by a reindex? I ask because I have a log file that looks to have gone from about 7gb to 13gb after running a reindex.

What is the log file filling with during a reindex? I was under the impression that a database with a SIMPLE recovery model does not store anything in the log file once a transaction has been committed ... so what if anything is the log file doing during and after a reindex?

ThanksStart Free Trial
 
Keywords: How are log files effected by reindexing?
Title
1 Reindexing
2 reindexing
3 Reindex having adverse effect on uplo…
4 Reindexing table
5 reindexing sysobjects
6 DBCC reindex
 
Loading Advertisement...
 
[+][-]06.08.2006 at 07:28AM PDT, ID: 16861646

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Databases Miscellaneous
Tags: file, reindex, databases
Sign Up Now!
Solution Provided By: napel25
Participating Experts: 1
Solution Grade: C
 
 
[+][-]08.01.2006 at 04:46AM PDT, ID: 17222755

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32