Shrinking a Published Database.. -- sql server replication

Brett
12/19/2003 3:02:21 PM

Hi

I want to shrink a database that I have that is currently
being published. I have about 19 GB worth of data in
about a 55 GB data file. I want to shrink the database
so that the database file is about 19 GB.

Is this possible to do without interrupting replication?
Do I need to change the recovery model?

Please advise..

Thanks,
Brett

Hilary Cotter
12/20/2003 11:26:54 AM

Replicating is insensitive to the recovery model. Put it into simple
recovery model and shrink away. If you have active transactions you
probably will experience some locking.

Ideally you would do this at 2:00 am or some period where there are very few
users on your system.

[quoted text, click to view]

sql server replication : Shrinking a Published Database..