Home > IT Answers > SQL Server > SQL Server 2000 Log File Size is increasing
Ynaina
5 pts.
 SQL Server 2000 Log File Size is increasing
SQL Server 2000
I have a sql server 2000 where log file is increasing very fast. My mdb file is 600 MB and Log file 6GB. How can i reduce the size of the file. Shrinking the file is not working.

Software/Hardware used:
ASKED: August 21, 2008  7:42 AM
UPDATED: August 21, 2008  9:47 AM
RELATED QUESTIONS
Answer Wiki:
What is the recovery level of the database? Have you backed up the database log? If you don't have the need for point in time recovery, change the recovery level to SIMPLE. After a few minutes SQL Server will clear out the log, and you will then be able to shrink the log file. If you do need point in time restore capability then you will need to backup the log using the BACKUP LOG command which will then clear the log allowing you to shrink the log file. ********************************************** run sp_dumptran to resize your log file size, it will automatically reduce after running it. but i was wondering why shrink is not working in your case?
Last Wiki Answer Submitted:  August 21, 2008  9:47 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.