July 15, 2008 at 1:54 pm
I have my File Data .mdf oout of space...it says File Size 33.3MB, and used size 33.0MB, how can I fiz this and give more space to this .mdf file?
Please any help??
Thanks.
July 15, 2008 at 2:35 pm
Assuming you have the disc space. Open SSMS, right click on the database name. In the menu that displays click on properties, another window will open. In the left pane of that window double click on "Files". Expanded that window so you can view all of it. Select the column titled "Autogrowth" To the right of the name click on the button with the .... in it, and it will give you choices for mdf file growth, either by percentage or actual KB. Of course click save when you are done, also do not forget to check your log file properties in this same window.
July 15, 2008 at 2:48 pm
It goes slike this:
Let the growth stay at 10% for now, when the Database is smaller, and you should try to reduce this when the DB grows bigger.i.e. lets say you Db Grows to 20GB, you can reduce the growth to 1%. But hey proper planning and Following the best practices will help you stay out of the WATERS...:)
Maninder
www.dbanation.com
July 15, 2008 at 4:00 pm
Excuse, any idea, how can I get some docs on this issue, I have several datafiles out of space, and I need to perform the same job over each one, also I need to avoid my log files still growing?
I am Junior DBA, I am trying to do my best and read a lot, but it is not enough to face this challenge now. I know I have to still doing that.
Please any idea.
Thanks.
OS WIndows server 2003
Sql Server 2005
July 15, 2008 at 4:54 pm
First step use Books On Line - click help on your SSMS menu - that produced:
Title: Considerations for the "autogrow" and "autoshrink" settings in SQL Server
URL: http://support.microsoft.com/kb/315512
Then try Google and you come up with:
Auto grow is a database file option that can be set to allow your database to automatically grow its data and log files in either percentage or fixed size increments as more disk space is required. This will kick in when database operations such as a large transaction occur and the file does not have enough space to accommodate the data required. Auto growing can be another performance killer for the same reasons as auto shrinking. I do set my databases to auto grow. However, I try to minimize auto growth by sizing my database files with enough space when they're initially created to accommodate future growth. In addition, I try to make my auto growth size large enough so this feature kicks in as infrequently as possible. Sizing your databases as large as possible at creation can greatly minimize the effects of physical file fragmentation. Allowing frequent auto growth to occur with auto shrink set could also potentially cause an interesting scenario where files are constantly growing and shrinking leading to rapid physical fragmentation as well as server performance issues. Monitoring your server's disk space on a regular basis should be a part of your maintenance activities.
From URL: http://www.mssqltips.com/tip.asp?tip=1481
Then search Technet URL: http://technet.microsoft.com/en-us/default.aspx
The search MSDN URL: http://msdn.microsoft.com/en-us/sqlserver/default.aspx
Each of the Microsoft pages have in the upper right hand corner of the web page a search box... use it for a given subject.
Be careful with your log files. In general do NOT shrink them, that said read the effect on log file size of how you back up your databases.
I saved this for last but it is NOT the least, but rather one of the better sites to get help. You can search SQL ServerCentral.com
After a short time period you will gradually assemble a list of sites on the web that you like and that have helped you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply