Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from mahendra_9179 on Mar 13 at 7:38 AM Hello David/Shriram,
I have tried on my development server.
Procedure:
1) First I took back up of transaction logs through SQL management studio.
2) Then I used shrink option through SQL management studio, where I chose first option "Release Unused Space".
3) Then again I took back up of transaction logs through SQL management studio.
4) And again shrink log file by using second option "Shrink File to".
And it worked for me.
So, can I proceed with same procedure on production server?
Regards,
Mahendra
| | | ---------------Original Message---------------
From: mahendra_9179
Sent: Wednesday, March 12, 2014 1:12 AM
Subject: SQL Log File Size is Extending Rapidly
Hello all,
We are using ECC 6.0, our database is SQL 2005 & operating system is Windows NT 4x AMD64 L.
Our database log file size is increasing rapidly, now its size is more than the all 4 data files (near about 300gb).
Last week I tried to shrink log file but it didn't worked.
Now less space is remained on disk, please help me.
Now the system is started giving dump at the time of log in, & the dump is like "START_CALL_SICK ".
Please help why this is happening.
Thanks in advance,
Mahendra |
| Reply to this email to post your response. __.____._ |   _.____.__ |
