SQL SERVER log file increasing remarkably
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi All, I am using SQL server 2000, one of my data base log file size has reached to the size of 30 gb. Even after transactional back up size did not decrease. Then I delete the log file and recreated it, still it is growing remarkably. My datbase setting for Recovery Intreval is 0(zero) minutes. Can anybody tell me why this file is increasing so fast? Thanks for the help.