Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Is it possible to shrink the data file of a SQL Server replication target server and continue the replication operation?
Ideally I'm trying to avoid shrinking the data file to reduce down time, then swap the roles if shrinking is possible.
There is 60% free space in the database after a bulk clean up, so shrinking is unavoidable.
With SQL Server transactional replication, data is replicated at the table level, not the database itself. So you can make whatever changes you want to the database. The question is why you want to shrink the database in the first place. Check out ShouldIShrinkMyDatabase.com, and make sure you click through to the linked article. – AMtwo May 21 '20 at 11:20
