Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hari_sql
Starting Member
22 Posts |
 Posted - 2010-03-22 : 07:26:50
|
| Hi,After some quite large processing in my DB (add/delete huge data), the Transaction log size has increased considerably. On executing DBCC SQLPERF(logspace), the log size displayed is 39489.8 MB and LogSpaceUsed is 96.23453%. I checked the size of .ldf file and it is 16.3 GB. So now I need to Truncate/Shrink the log file. A few queries along this line:1. What is the difference between Truncate/Shrink T-log file?2. How to Truncate/Shrink the T-log? 3. Is there any special precaution to be taken during the Truncate/Shrink action?Any help would be greatly appreciated.Thanks & Regards,Hari. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-03-22 : 08:34:58
|
| Full recovery model? Running log backups at all?Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Truncate/Shrink T-log