My sql server database ldf file size is too much from mdf file approx 1 gb. How I can reduce this.
Even I set recovery model simple.
And using sql server 2008 r2
Your question doesn't make any sense as posted. Are you considering the log file too big or the data file? If it is the log file just setting the recovery model to simple isn't going to reduce the size of the file. This topic is WAY beyond the scope of a forum post. You should check out the stairways article discussing how to manage log files. http://www.sqlservercentral.com/stairway/73776/[/url]