Search This Blog

Friday, December 23, 2011

Shrink Database log files in SQL Server 2008

If you want to shrink the databases log file then here is the process for SQL Server 2008.

-Right click on the Database --> Tasks --> Shrink --> Files

-Select the 'File Type' as 'Log'

-Select 'Reorganize pages before releasing unused space' and modify the size.

-Click 'OK'