I have a set of database on full recovery model, my backup schedule looks like this:   1 Weekly Full Backup 1 Daily Log Backup   Full backups are about 10GB, log backups are about 500mb per day.  What happens is that right now, I'm having a DataFile of 10GB but a log file of 30GB...  Could be an option to shrink the log file? Is this a good practice? I have read that is not recommended but I don't know the exact reason.  Thanks!
This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this:  In SQL Server -  What are some reasons the transaction log grows so large? Why is my log file so big? What are some ways to prevent this problem from occurring? What do I do when I get myself on track with the underlying cause and want to put my transaction log file to a healthy size?
Equivalent of cURL for Ruby? How can I customize a system locale? A user just posted his question a second time here on meta after the first was closed as a duplicate. I wrote a comment on the second post, explaining that the answer to his question is in the linked duplicate and that he shouldn't circumvent the closure process by asking a second identical question.  When the second post was closed as a duplicate my comment was automatically deleted. As far as I understand this is a heuristic that removes obsolete comments, which it considers every comment that contains a link to one of the duplicates.  This heuristic is too aggressive and removes comments that go beyond "Duplicate here: link". I suggest that it should be changed to only remove the default duplicate comment, and not any comment that was edited by the owner nor any free-form comment that happens to include a link to the duplicate.  This also triggers for any comment that contains the word "duplicate" and link to any question, not only the question being chosen as duplicate, which makes this much worse. As the title of the Question states, I want to know what are the tools available for Ubuntu which would allow me to take screenshots of "Scrolling Windows" ie; tall webpages, tall nautilus window which contains lots of files and folders etc. as a single image file.  For the sake of clarity, I have already seen . However, I am specifically looking for tools to capture Scrolling Windows.  As an example, my personal favorite for Microsoft Windows is . It's light on resources and helps me take beautiful screenshots. Is there anything close to it available for Ubuntu? What's the difference between mobile and desktop processors? Retrieving HTTP status code from loaded iframe with Javascript Specifying latest revision of a particular branch with bower Evaluate definite interval of normal distribution I know that an easy to handle formula for the CDF of a normal distribution is somewhat missing, due to the complicated error function in it.  However, I wonder if there is a a nice formula for $N(c_{-} \leq x &lt; c_{+}| \mu, \sigma^2)$. Or what the "state of the art" approximation for this problem might be. Why General Leibniz rule and Newton's Binomial are so similar? The binomial expansion:  $$(x+y)^{n} = \sum_{k=0}^{n} \binom{n}{k} x^k y^{n-k}$$  The General Leibniz rule (used as a generalization of the product rule for derivatives):  $$(fg)^{(n)} = \sum_{k=0}^{n} \binom{n}{k} f^{(k)} g^{(n-k)}$$  Both formulas can be obtained simply by induction; Newton's binomial also has a combinatorial proof . It's striking how these formulas are similar; is there a possible connection between them? I was thinking that maybe the General Leibniz rule could be obtained using a combinatorial argument as well (hence the binomial coefficients)... How to cite sources written in a different language than English? Assume one wants to cite a paper written in a different language than the article citing said paper (e.g., ones own article is written in English, but the source is French).   How to properly handle citation in such a case?  Do I cite the original (French) title or a translated title? If I use a translated title, people might have a hard time to find the source; if the original (French) title is cited, people might have a hard time understanding it. How to solve this limit: $\lim\limits_{x\to0}\frac{(1+x)^{1/x}-e}x$? I tried to evaluate $$\lim_{x\to0}\frac{(1+x)^{1/x}-e}x$$but all my efforts were in vain . L'Hospital rule becomes very complicated. To env or not to env Why isn't dark matter just ordinary matter? There's more gravitational force in our galaxy (and others) than can be explained by counting stars made of ordinary matter. So why not lots of dark planetary systems (i.e., without stars) made of ordinary matter? Why must we assume some undiscovered and unexplained form of matter? Consider the sum of $n$ uniform distributions on $[0,1]$, or $Z_n$. Why does the cusp in the PDF of $Z_n$ disappear for $n \geq 3$? I've been wondering about this one for a while; I find it a little weird how abruptly it happens. Basically, why do we need just three uniforms for $Z_n$ to smooth out like it does? And why does the smoothing-out happen so relatively quickly?  $Z_2$:     $Z_3$:    (images shamelessly stolen from John D. Cook's blog: )  Why doesn't it take, say, four uniforms? Or five? Or...? How does wizard & cleric spell preparation and casting work? In 3.X wizards had spellbooks, while clerics had their entire spell list, but they both memorized/prepared spells every day from those lists, and had a certain number of slots for preparing spells in.  Now in 5e preparing spells and spell slots aren't the same thing. What's going on here? How does their spellcasting work now? I've always wondered this - why can't you declare variables after a case label in a switch statement?  In C++ you can declare variables pretty much anywhere (and declaring them close to first use is obviously a good thing) but the following still won't work:  switch (val)   {   case VAL:     // This won't work   int newVal = 42;     break; case ANOTHER_VAL:     ...   break; }     The above gives me the following error (MSC):     initialization of 'newVal' is skipped by 'case' label   This seems to be a limitation in other languages too.  Why is this such a problem? How do I prove that then $f(x) = 1$ for some $x ∈ [0, 1]$? We are asked the following:      let $f(x)$ be a continuous function on $[0, 1]$ such that   $$\int _ {0} ^ {1} \ f(y) dy = 1$$   prove that $f(x) = 1$ for some $x ∈ [0, 1]$   The question asks to take into account Rolle's Theorem and Mean Value Theorem.  I'm aware of the definitions, but I am really unsure how to answer this question and my tutors are not really responding till after easter.    Could someone please help? Why is there a "y" involved?  Thanks you Why does C# disallow readonly local variables? How can I swap or replace multiple strings in code at the same time? I've found several posts with this same question, but the answers always diverge to some other topic or they don't work for my needs.  After a node is saved, I want my custom module to insert a row into one of my custom tables which contains the nid of the new node. When hook_node_submit is called, the nid doesn't exist yet. hook_node_insert does have the nid, but only gets called the first time the node is saved, but I potentially need to take action each time the node is saved.   My plan is to separate my functionality into its own method and implement both hooks, but I'm trying to learn to do things properly with Drupal and so I'm wondering if there is a hook that actually fits with my requirements.  Is there a hook which is called every time a node is saved and called AFTER the save is complete?