Thursday, March 22, 2012

database size

Is there any shortest way to database size (data & log)
I refer to Article ID: 256650 (reduce log file size)
Quit a lot of step
I want to reduce physical occupied HDD sizerefer BOL,
dbcc shrinkdatabase and dbcc shrinkfile|||Chiwaki
Before that I suggest you to assess the required value for Transaction log file, if you are trying to shrin the Tlog with DBCC SHRINKFILE and if the batch jobs such as bulk load and database maintenance will try to increase the size to process the statements.

So it is better to assess the size in advance to avoid such Open/Close operation.

Hope this helps.

No comments:

Post a Comment