Truncating Log Files and Recovering Space : SQL 2005
Truncating Log Files and Recovering Space in Microsoft SQL Server 2005
Excerpts:
A common issue for users of SQL Server databases is disk space and the size of the physical log file and database. While we're not going to attempt to make "one size fits all" statement on database maintenance plans, we though it would be helpful to provide a few suggestions that will help you trim the size of your files when you are in a pinch.
For more details click here
or
you can click on the following link
Amazing..thank you so much for this post.. I was trying to come out from this problem for a long time.. now its done.
ReplyDelete