June 26, 2009 at 7:37 am
Hi all,
I facing the strange issue with tempdb database in SQL Server 2005
I changed the tempdb log file autogrowth property from Unrestricted to restricted It worked.
Again I tried to change the tempdb log file autogrowth property from restricted to unrestricted It is not working, but it is working for tempdb data file.
First I tried with Management Studio, then It ried with below SQL QUERY and restared the SQL Server, not working.
ALTER
DATABASE TEMPDB MODIFY FILE (NAME = TEMPLOG, MAXSIZE = UNLIMITED)
It is very urgent..
Can someone help me why SQL Server is behaving like this.
Rajesh Kasturi
June 26, 2009 at 9:08 am
Rajesh: if there are transactions happening on the server and going through tempdb, it will not work.. tempdb has to be in quite mode(single user) or there should be no tranactions etc... to work with.... if i am correct...
Maninder
www.dbanation.com
June 26, 2009 at 10:48 am
Manu,
It is happening for the tempdev.mdf file, but It is not happening for the Log file.
May be I have to try by putting in single user mode...
Are you sure it will work if we put in single user mode, because mine is production DB.
Rajesh Kasturi
June 26, 2009 at 11:57 am
Why do you think it is not working? If you have a very large number as the restricted size of the file, are you aware that the number is in megabytes (MB) and that this size is equal to 2 TB (terabytes)?
What is happening is that it is showing you that the file is restricted to the largest size the log file can be.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
June 27, 2009 at 8:44 am
Jeffrey Williams (6/26/2009)
Why do you think it is not working? If you have a very large number as the restricted size of the file, are you aware that the number is in megabytes (MB) and that this size is equal to 2 TB (terabytes)?What is happening is that it is showing you that the file is restricted to the largest size the log file can be.
Hi Jeffrey Williams,
You are right, Right now I am not in office, I will check and let you know.
Rajesh Kasturi
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply