Home Forums SQL Server 2005 SQL Server 2005 General Discussion Shrinking Database RE: Shrinking Database

  • July 28, 2009 at 4:11 am

    #1030930

    trayalacheruvu (7/28/2009)

    hi,

    Thanks for your quick update update.. Actually i am rebuilding the indexes every during the non-working hours.. ok after Shrink the Database i need to rebuild the indexes. the performance will be as usaual right?

    Thanks,

    thulasi

    You should not rebuild your indexes so often. this again makes your log files to grow heavily... Rebuiling indexes will, however, keep the performance right.


    Pradeep Singh