SQL Server Performance

Shrinking Model Database

Discussion in 'SQL Server 2005 General DBA Questions' started by danny123, Aug 24, 2010.

  1. danny123 New Member

    Hi there,
    Is there any harm if i need to shrinkl the Model database? Is there any thing different I need to do or the same process to shrink as user databases.
    Thanks!
    danny123, Aug 24, 2010
    #2

  2. melvinlusk Member

    You shouldn't have a problem shrinking it just like any other user database. Keep in mind that it's kept in FULL recovery mode by default.
    melvinlusk, Aug 24, 2010
    #3

  3. satya Moderator

    What is the size of model database at your enviornemnt?
    Why do you want system database to reduce their size?
    What is the free space on disk where system databases are stored?
    You might think to move TEMPDB to seperate drive to save lots of space, it looks that is used extensively from SQL 2005 onwards.
    I wouldn't recommend SHRINK system database in any case.
    satya, Aug 24, 2010
    #4

Share This Page