Restart the sql server services....
-----Original Message-----
From: Venkataramani S.
[mailto:mssqldba-ezmlmshield-x20339155.[Email address protected]
Sent: Friday, March 28, 2008 1:35 PM
To: LazyDBA Discussion
Subject: tempdb datafile size grows to 90 gb
Hi,
I got this error message in my log file.
"Autogrow of file 'tempdev' in database 'tempdb' took 64328
milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH
for this file."
Suddenly my temp db datafile size grows to 90 gb. I have enabled auto
growth. When I checked the spaceused it used only 2 mb and remaininig in
unallocated zone.
I did shrink database and shrinkfile to reduce it to default size but
nothing happened.
Pls friends help me out in this issue. very urgent I am running out of
space.
Thanks in advance
Venkat
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Cellebrum.com Pvt Ltd or its affiliates and/or subsidiaries must be taken not to have been sent or endorsed by any of them. Opinions and information in this email that do not relate to the official business of Cellebrum.com Pvt Ltd, shall be understood as neither given nor endorsed by Cellebrum.com Pvt Ltd. Any action/proceeding/opportunity upon the contents of this email taken by not intended addressee shall attract liabilities both criminal and civil against such addressee.
Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect.
MS Sql Server LazyDBA home page