Post reply

tempdb MODIFY FILE failed. Specified size is less than current size.

  • June 6, 2009 at 7:16 am

    #131030

    Hey guys,

    http://support.microsoft.com/default.aspx/kb/307487

    Haven't had to do this in awhile, but trying to shrink my tempdb data file down below it's current allocated size. Allocated additional size to it during a migration and now I need to move it back to a smaller drive which can't support it's size as of now.

    I'm on windows 2008 and it won't let me run sqlservr -c -f nor net start mssqlserver -c -f, access denied on the net start and unable to init error log on sqlserver. I was able to get up in minimal config mode by using -c;-f in config manager, but even after issuing my alter and shrink statements, I'm still getting "specified size is less than the current size."

    Any and all help is greatly appreciated.

    Thanks

  • June 6, 2009 at 7:22 am

    #1005693

    Of course, I make a post and then a few minutes later fix it ... bah, I'm good.

    I issued the alter to move and change size at the same time and it recreated at the smaller size just fine. I'm smart.

    Thanks anyways

  • August 5, 2009 at 6:15 am

    #1034707

    Hi Adam

    Can you please send me the code for what you did in your post?

    I'm having the same issue; when Im trying to alter the db, i get the following error:

    MODIFY FILE failed. Specified size is less than current size.

    Pretty please 🙂

    Many thanks

    Anchelin

    Code:

    ALTER DATABASE Dbname

    MODIFY FILE

    (NAME = dbname_2,

    SIZE = 5000 KB);

  • August 5, 2009 at 6:39 am

    #1034728

    Adam Bean (6/6/2009)

    Of course, I make a post and then a few minutes later fix it ... bah, I'm good.

    Wrong... WE are good 😀

    Just by posting in this forum you got the answer directly sent to your brain!... are we good or what?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • August 5, 2009 at 7:07 am

    #1034750

    Are you talking about tempdb??

    If not, Can you not shrink the file?

    DBCC SHRINKFILE (logicalfile, size in mb)

  • July 25, 2012 at 3:55 pm

    #1517657

    Hi,

    I am in the same situation. I need to modify the size of the tempdb lower than its current size. Can you please post the command how you did it both "move it to new location and change file" at the same time.

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply