Hi All,
I have a production database in SQL 2000 server. It is configured to truncate on check point. when ever I check the log size by right click on database and choose property and then logfile the size is keep on showing the ever growing transaction file size. I truncated the logfile and restarted the server. No new news.
The transaction log file is set to unlimited growth.
Can you please tell me how do i get the file shrink to its orginal value?? The files are set to shrink files option.
Any advice would be gratly appreciated. (The Transaction file size is 41 gig, initially it was set to 1gig)