March 2, 2018 at 9:16 am
Dear Friends
is it possible to limit the size of the sql server log in megabytes?
Thanks
Almir
March 2, 2018 at 9:48 am
almirfiorio - Friday, March 2, 2018 9:16 AMDear Friendsis it possible to limit the size of the sql server log in megabytes?
Thanks
Almir
No offense meant but did you even try? This is painfully simple to find the answer. https://www.google.com/search?q=sql+server+limit+log+file+size&ie=utf-8&oe=utf-8&client=firefox-b-1
_______________________________________________________________
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/
March 2, 2018 at 9:52 am
almirfiorio - Friday, March 2, 2018 9:16 AMDear Friendsis it possible to limit the size of the sql server log in megabytes?
Thanks
Almir
Doesn't look like it, but then that isn't something I would concern myself with either.
March 2, 2018 at 9:58 am
Looking at another one of your posts, are you talking about the transaction log of a database? Yes, you can configure how large that can become, but if you fix the size then you have to carefully monitor the log to ensure it doesn't become full as that would result in your database becoming unusable until you correct the issue.
You seem to be asking random questions. What are you trying to accomplish?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply