April 26, 2012 at 5:13 am
Dear Sir,
I have facing problem in my SQL 2005 DB auto grow,
Following is the File Status
Initial Space : 6.00 MB
Used Space : 5.44 MB
Available Space : 0.56 MB
Auto Growth Parameter is configured as “By 1 MB, unrestricted growth.”
My DB is unable to auto grow.
Please help.
Thanks
Thanks
Adeel Imtiaz
April 26, 2012 at 5:18 am
do you get any errors?
You're better off pre-allocating the space required for the data and log files. Growing data files/log files is a resource expensive operation, so you want to restrict how often it occurs. Also, look at instant file initialization - grant the service account running the SQL Server service account Perform Volume Maintenance 'via Local Policy manager
April 26, 2012 at 5:19 am
adeel.imtiaz (4/26/2012)
My DB is unable to auto grow.
1) Are you able to enter data into this database?
2) Are you getting any error messages?
3) Is the drive full?
April 26, 2012 at 5:29 am
Usually that would be an indication of a full drive. There must be an error or a message or something.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2012 at 5:57 am
Please see that the drive is not full . there is lot of space available .
I have noticed that i do not have any Service pack installed on my SQL 2005 Database its version is
(Version 1399).
We actually also assumed that space will be automatically allocated, but for some reason this auto growth working is not performing at all. we were just updating a row in a table. Enable Auto grow option is also set to true. there is 20 GB free Space available in Hard Disk.
April 26, 2012 at 5:58 am
There is no accurate time for error , it comes any time.
April 26, 2012 at 6:03 am
just want to add one more thing regarding this issue, that when we manually allocated the size, everything start working normally.
April 29, 2012 at 11:18 pm
Should i install Sp2 of SQl 2005
May 1, 2012 at 1:41 pm
I would go to at leaste Service Pack #4 and MS11-049 Build 5292 - June 2011.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
May 3, 2012 at 5:53 am
I have installed SP4 of SQl 2005 and problem has been resolved.
Thank you doctor.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply