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 knowism on Mar 12 at 1:47 AM
Hi mahendra,

You would need to extend the drive that holds the log file. After you do, you need to schedule a database log file backup on tcode DB13. An hourly log backup is a good start. A regular log backup results in a manageable size for the log file.

At your option, you may want to shrink the log file size using the SQL Management Studio.

---------------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
knowism  

achievement
 
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