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'
-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'
No comments:
Post a Comment