We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] SQL Log File Size is Extending Rapidly

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from D. Caddick on Mar 12 at 2:40 AM
Hi Mahendra,

You say you have performed a Log Backup with MSSQL Studio, right?
This should have emptied the log file container.
You then should be able to shrink the log file. Make sure you
have scheduled regular Log Backups.

You might have to stop/start the SAP system to get the shrink utility to work. This might also include stopping the SQL Server service.

Regards

---------------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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2014 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
D. Caddick  

Consultant
12 achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language