Microsoft SQL Server 2005
Two simple steps on how to shrink database log files using SQL Server Management Studio (SSMS):-
1. Open SSMS > login Database Server > Right Click Database that you would like to shrink > select Task > Shrink > Files
as shown in figure below.
2. Do a full backup first!. Select "Log" in File Types and check carefully before you click "OK".
Please be remind that to restart your database server to refresh, otherwise you will be facing a problem where you couldn't find your tables data on the next day!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment