December 30, 2010 at 12:27 am
i have 1 filegroupe and 1 file in it . and i assigned many tables on to my file .i want to chane maxsize of my file?what can i do?
December 30, 2010 at 1:01 am
You can set the maximum size for each file in your filegroup.
The filegroup size is the total of all the files sizes that belong to the group.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 30, 2010 at 1:31 am
ok .where can i do change size???
December 30, 2010 at 3:59 am
In SSMS, right click the database you want to modify.
Select properties.
Select "Files" from the list on the left.
All files that belong to the database will be displayed (your database file, and log file)
There is a column "Initial Size". Make sure the size you assign is the same OR bigger than the files current size.
Why increase the size? are you expecting major growth?
You know the database has the capability to grow itself as needed? (Also under the file properties, look for "Autogrowth" column. You can set it in % or MB (recommended).
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply