By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

How to clear Secondary log files

P: 3
My log files became full and I killed the application which used up the log space and finally i was able to free up the log space.

Now the issue is that I have freed up the Primary log space but the Secondary log space shows that it is using up the total number of pages allocated to it (In my case 20 pages)

So my question is how do i clear up the secondary log space and why wasen't it freed when i killed the application using up the log space. It freed up the primary log space !

At present i am not facing any problems with the secondary log space as there is enough primary log space. But i also wanted to know if it wil cause any issues in future.

Thanx in advance !
Sep 19 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.