July 8, 2011 at 5:33 am
I asked a similar question before but i practically got no answer.
I am running a shrink on a large filegroup of my database (around 1TB) i will put the db in restricted mode and let it run (so there will not be any transactions). Does running a shrink generate a lot of log volume? I am afraid i will run out of backup disk space because of the Incremental backups that the redgate is running every 10 min, this is the reason i am asking this.
If anyone knows please clarify this for me as i am a new DBA.
Thank you
July 8, 2011 at 6:02 am
Yes, shrinking generates log.
Why are you shrinking? Is there a really good reason?
p.s. SQL doesn't have incremental backups. You mean Diff? Those will be larger than normal because the shrink will be changing large portions of the DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2011 at 6:58 am
yes reason is that tables have changed filegroups.
So i am looking at massive log backups when the backup is running... That is good to know but scary.
July 8, 2011 at 7:05 am
Cool. Don't forget to rebuild indexes afterwards (any that are in the filegroup you shrunk)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply