Friday, February 24, 2012

dbreindex and differential backup

Will DBCC DBReindex cause database pages marked as changed so differential backups will bakcup the whole database? Thanks.That is very possible. It's usually a good idea to just do a full backup on
the db if you reindexed all the tables.
--
Andrew J. Kelly
SQL Server MVP
"digi" <anonymous@.discussions.microsoft.com> wrote in message
news:863E59AD-E1E7-4DAB-B05F-2E990563504E@.microsoft.com...
> Will DBCC DBReindex cause database pages marked as changed so differential
backups will bakcup the whole database? Thanks.

No comments:

Post a Comment