Showing posts with label bakcup. Show all posts
Showing posts with label bakcup. Show all posts

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.

dbreindex and differential backup

Will DBCC DBReindex cause database pages marked as changed so differential b
ackups 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.|||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.