Steps To Determine Current SQL Server Database Sizing
- Start SQL Server Management Studio
- Right click on the Coreflex database (usually CFXWMS) and select Properties
- Record the Size and Space Available from the General Page
- Record the intial size and growth settings for all data files and log file(s) from the Files page:
- The end result should be something like this:
- Also it is advisable to add a date/time column.
Size (MB) |
Space available (MB) |
Data File (MB) |
Log File (MB) |
Notes - Autogrowth. |
44.38 |
.30 |
37 |
9 |
Data File Growth 1MN, unrestricted / Log - Growth by 10%, restricted to 2,097,152 MB |