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