Showing posts with label orfully. Show all posts
Showing posts with label orfully. Show all posts

Friday, February 24, 2012

Is DBCC DBReindex minimally logged operation?

Hi gurus,
Does anyone know whether DBCC DBReindex is a minimally logged operation or
fully logged operation?
Thanks,
Jeff" fully logged "
--
"Jeffrey Yao" wrote:

> Hi gurus,
> Does anyone know whether DBCC DBReindex is a minimally logged operation or
> fully logged operation?
> Thanks,
> Jeff
>
>|||It is minimally logged when the database is in simple or bulk logged recover
y mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jeffrey Yao" <jxhyao1@.shaw.ca> wrote in message news:%235UKdhHqFHA.1556@.TK2MSFTNGP12.phx.g
bl...
> Hi gurus,
> Does anyone know whether DBCC DBReindex is a minimally logged operation or
> fully logged operation?
> Thanks,
> Jeff
>