itsgaurav (2/11/2016)
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
Thanks
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]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/