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 |
|
ppatel112
Starting Member
35 Posts |
 Posted - 2012-07-05 : 22:12:41
|
| Hi there,i need some advise on truncating a big transaction log file.it is a production database.CRMEx_log Initial Size is set to 365,972MB, which is 365GB.autogrowth is set to 10 percentCRMEx_log is 374GB, we need to shrink it, not sure why it is so huge??the hard disk in running out of spaceplease advise on what procedure to be followed to fix it.regards,parth |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-05 : 22:45:40
|
| see what has caused log to grow in size . is it some uncommited transaction? check trancount------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Truncating Transcation log file