database sizes????

  • when right clciking properties in enterprise manager

    database tempdb

    status normal

    General tab size 7000mb

    space available 6880mb

    transaction log space allocated 2000mb

    automatically grow file

    in megs 100mb

    restrict filegrowth to 2001mb

    actual size of templog on server is 2048mb

    should I increase the size of restrict file growth size.?? or is this okay, will this cause problems because sze is above max filegrowth.

  • It's generally not a good idea to restrict the tempdb as it needs to be able to grow dynamically

    What recovery mode is your tempdb set to?, should be Simple (but don't change this during production time...)

    Max

Viewing 2 posts - 1 through 1 (of 1 total)

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