Post reply

Reorganize Index, Database Integrity check, Update Statistics required for System Databases

  • November 8, 2010 at 4:44 am

    #242690

    Hi All,

    do we need to have Reorganize Index, Database Integrity check, Update Statistics required for System Databases?

    Thanks in Advance!

  • November 8, 2010 at 4:54 am

    #1247578

    Sqlsavy (11/8/2010)

    Hi All,

    do we need to have Reorganize Index, Database Integrity check, Update Statistics required for System Databases?

    Thanks in Advance!

    It depends.

    In my case maintenance for system db's,

    1.Backup --yes (Except tempdb)

    2.Reorganize Index --no

    3.checkdb --yes (Except tempdb)

    4.Update Statistics --no

    Do you have any tables and SPs in your system database.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • November 8, 2010 at 5:00 am

    #1247580

    Thanks!

    No I don't have any user tables in System db's.

    I do take backup of system db everyday. But why can't we have Reorganize Index,Statistic checks?

    Tnaks

  • November 8, 2010 at 5:10 am

    #1247584

    Sqlsavy (11/8/2010)

    Thanks!

    No I don't have any user tables in System db's.

    I do take backup of system db everyday. But why can't we have Reorganize Index,Statistic checks?

    Tnaks

    There is no need for do the Reorganize Index,Statistic because you are not touching the any objects.(i meant updation)

    Edited:for remove the line.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • November 8, 2010 at 6:33 am

    #1247622

    Thanks!

  • November 8, 2010 at 6:38 am

    #1247626

    muthukkumaran (11/8/2010)

    1.Backup --yes (Except tempdb)

    2.Reorganize Index --no

    3.checkdb --yes (Except tempdb)

    4.Update Statistics --no

    What about MSDB ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • November 8, 2010 at 6:42 am

    #1247629

    Bhuvnesh (11/8/2010)

    muthukkumaran (11/8/2010)

    1.Backup --yes (Except tempdb)

    2.Reorganize Index --no

    3.checkdb --yes (Except tempdb)

    4.Update Statistics --no

    What about MSDB ?

    Did you read my replay fully ?

    It depends.

    In my case maintenance for system db's,

    1.Backup --yes (Except tempdb)

    2.Reorganize Index --no

    3.checkdb --yes (Except tempdb)

    4.Update Statistics --no

    Do you have any tables and SPs in your system database.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • November 8, 2010 at 6:42 am

    #1247630

    Sqlsavy (11/8/2010)

    Thanks!

    your welcome.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 8 posts - 1 through 7 (of 7 total)

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