Thursday 16 February 2012

Shrinking MS-SQL Database

Normally shrinking a database increases performance and reduces size only by a small margin.

The following process helps to shrink the database and increases performance by a huge factor.


1 - Take  Transaction Log  backup twice.

2 - Then shrink the Database.

No comments:

Post a Comment