Is Database shrinkage possible in Replication ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Is Database shrinkage possible in Replication...

Is Database shrinkage possible in Replication ?

Rate Topic

Display Mode

Topic Options

Author

Message

diva.mayas

Posted Tuesday, May 04, 2010 12:18 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, August 18, 2010 9:45 AM
Points: 21, Visits: 77

Is Database shrinkage possible in Replication ?

Post #915091

sqlvogel

Posted Tuesday, May 04, 2010 12:26 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:10 PM
Points: 406, Visits: 2,853

Do you mean is it possible to shrink the database files using the DBCC SHRINKFILE or DBCC SHRINKDATABASE commands? Yes it is possible. In general shrinking databases is not a good idea, whether replicated or not. Do it only for exceptional reasons and don't do it regularly.

David

Post #915095

diva.mayas

Posted Tuesday, May 04, 2010 12:37 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, August 18, 2010 9:45 AM
Points: 21, Visits: 77

Thanks David,
one more assist you have specified - [ Do it only for exceptional reasons ]
Can you specify the exceptional reasons or if anybody has faced such situation.
I need to know for my knowledge purpose.

Post #915096

« Prev Topic | Next Topic »

Permissions