Shrink database?

[mkal]

I have a database that participates in logshipping. Right now the database (47.5gb) file for the Primary db is quite large and has considerable free space (24gb) . I would like to shrink the database to regain most of the free space.

My question is there anything special I have to take into consideration or can I just run a dbcc shrinkfile('dbname', 25000).

And if I shrink the Primary will the Secondary also be shrunk to the same size?

Thanks

 

[mrdenny]

Nothing special needs to be done.

The server you are shipping the logs to will shrink as well as the log is shipped.

Shrink the files in small batches. As the data is moved within the file, the log will show and massive logs will be shipped to the destination.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog