Wednesday, 28 March 2012

How to Reduce the SQL Database Size


Please see the Following steps for Reduce the MS SQL Database size

    1)    Don’t try to truncate any table
    2)    select DATABASE-> right click ->Tasks->Shrink->Database
    3)    select DATABASE-> right click ->Tasks->Shrink->files
    4)    select DATABASE-> right click ->Tasks-> take offline
    5)    select DATABASE-> right click ->Tasks-> detach
    6)    delete or rename log file

   Go to your Database directory 
   ~\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\

   Delete or rename ” DatabaseName. LDF” file

    7)    Click Database -> Attach




No comments:

Post a Comment