Results 1 to 3 of 3

Thread: Tempdb Size

  1. 06-11-2007, 09:02 AM #1
    bobbo's Avatar
    bobbo
    bobbo is offline Registered User
    Join Date
    Oct 2005
    Location
    Ireland
    Posts
    92

    Tempdb Size

    when I restart SQL server my tempdb database is 1.9Gb. I thought it was deleted and replaced with a copy of the model database. Is this not so?
    Reply With Quote Reply With Quote
  2. 06-11-2007, 10:50 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    No, it gets created with the last size that you had manually expanded to. You can check it from master..sysaltfiles entry.
    Reply With Quote Reply With Quote
  3. 06-11-2007, 01:10 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    if you had never changed the tempdb size manually then it takes the size of model database

    If you had changed it to 1.9Gb then next time when it starts it will start with 1.9GB.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules