I have a SQL Server 2016 Enterprise database server that I have recently inherited.  One instance on this server has an application that uses two different databases.  One of these is the actual application database and the other is used to generate reports and dump data from the first.  The second database has several stored procedures that run at different times, including one that dumps data from a view into a CSV file for offsite storage of the data that runs every 15 minutes.  When I initially got this database, the recovery model was set to simple and a database backup was being taken nightly.  Since, I have changed the recovery model to full and changed the backup plan so that it is taking full backups twice weekly, differential backups twice daily and log backups every three hours.  However, even with this change, the transaction log for the second database is staying around 300GB.  Each transaction log backup is around 80GB.    I have plans to dig into how the stored procedures work and hopefully simplify some the way these things run, but that is going to be a long term project.  In the short term, I need to find a way to determine if the transaction log is being truncated correctly and if there is anything I can do to reduce the size of the transaction log on this database.  I've looked at the log with the fn_dblog function hoping to see if there were old transactions being stored, but most of the Begin Time and End Time records are null.    Other than a complete rewrite of the system (which is in the works), does anyone have any suggestions for getting a handle on this log file?
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?
Move the period outside the quotes on the site-analytics page If you don’t have 25k reputation, the  contains a stub text:        As you can see on the image, the dot should be moved outside the quotes. Also, on ruSO we need to  from “” to «», but this is not possible via Transifex, because there is no full sentence available to translate. Let $f: B(0,1) \rightarrow \mathbb{C}$ be holomorphic and suppose $\exists\ r \in (0,1)$ such that $f$ is injective in $A = \{z \in \mathbb{C} : r &lt; |z| &lt; 1\}$. Prove that $f$ is injective.  I tried using Rouché theorem, or the identity theorem, but I don't know what to do. Any hints? :) In iOS 6 and below I could double tap the home button, tap and hold an app, and  click the red - to close an application(s).  In iOS 7 this does not work. How can I restart an app that's exploding without resetting the entire OS? Cu has an unpaired electron in 4s, but it is diamagnetic. I thought that it has to be paramagnetic. What am I missing? What could cause a toilet to leave the flapper up and keep running? I have an American Standard toilet I installed last year. I don't know much about plumbing, but I was able to install this toilet. It seems to function okay, except for what I think is a mechanical problem.  Sometimes when the toilet is flushed, the flapper doesn't close and water keeps running.  The handle feels like it's slightly stuck in the up position.  I looked inside the tank once when it was doing this, and the chain attached to the handle was slack. I don't understand why the flapper isn't closing.  I've tried putting more slack in the chain and loosening the plastic nut that holds the handle on the toilet, but it doesn't seem to be helping.    How can I fix this? Dual boot with windows 7! I'm using windows 7 right now. I want to install Ubuntu with dual boot. Is is safe? And does the process go safely? Flag abusive users I think the community does a great job policing questions/answers, etc. and the community has some good tools available to do this.  Between flagging questions with some reasons behind it and editing posts, closing them, and deleting them, the only thing that seems to be missing to me is the ability to flag a user.  Reasons to flag a user as abusive:   Duplicate User Abusive Behavior Offensive user name or profile User profile consists of spam Others? This is a  about DNS/Hostnames resolution to IPs/Ports   Example 1  I'm running a web server on port 80 and another on port 87. I would like to use DNS so that www.example.com goes to port 87. How can I accomplish this using DNS only?  Example 2  I'm running a service on my server on a non-standard port. How can I get clients to connect to this non-standard port automatically? Can I use DNS? Is there some application specific support where DNS could indicate the IP and Port?   Example 3  Do some application protocols specifically support hostname awareness, and allow special actions to be taken based on this information? Are there other questions on Server Fault that cover some of these?  Commandeering: This question was originally asking about running IIS and Apache on the same server, but the same concepts can be applied to any server software receiving connections from clients. The Answers below describe the technical problems and solutions of using DNS and application protocol support to assign a port number for a client to connect. How to normalize data between -1 and 1? I have seen the min-max normalization formula but that normalizes values between 0 and 1. How would I normalize my data between -1 and 1? I have both negative and positive values in my data matrix. Passcode is required to enable Touch ID This morning I experienced the weirdest thing by my iPhone 6S requiring me to enter my passcode rather than allowing me to use my finger as Touch ID.  My phone was locked probably for like 4 hours while charging overnight and as far as my knowledge my phone did not restart during this time since my Stack Exchange app was left open and upon opening it the same content were still there.  I didn't attempt even once to use my Touch ID; if I would've had a faulty Touch ID sensor then I should've seen such similar behavior either prior to this morning or at least afterwards (I'm already on my phone for the past 3 hours plus).  I didn't register or delete any fingerprints for months.  And finally, I don't have any restrictions setup to require the input of my passcode under Settings > General > Restrictions.  I'm running on iOS Version 10.0 beta 3 (14A5309d)  Anyone out there that has also experienced such similar behavior or with any suggestion on what might've caused it? What are the consequences of using a low-wattage USB-C power supply with a MacBook Pro? Why do Lambertian Reflectors Privilege the Observer? Somebody asked me this question in a job interview and I replied that their joint distribution is always Gaussian. I thought that I can always write a bivariate Gaussian with their means and variance and covariances. I am wondering if there can be a case for which the joint probability of two Gaussians is not Gaussian? What do they do with all the plates and cups in Star Trek? Whenever someone in Star Trek creates food or drink in the replicator it is generated in the bowl, plate, or cup. It seems like after a few months they would have piles of used dishes from replicator food while making more for every meal. What do they do with all the dishes? Is there any data in Tolkien (books/letters/etc..) to explain why there were precisely 9 Men rings and 7 Dwarf rings and 3 Elf rings? (the latter assumes that Sauron planned the number of Elvish rings to be 3 before he was thwarted by Elves making the rings themselves)  Was it because of the amount of tribes/kings he needed to deal with? Some magical/power limitations? Magical properties of numbers 9 and 7 (ala 7 Horcruxes)? A whim of Sauron's?    UPDATE: Looks like 3 and 7 are explained in the answers (3 elf lords and supposedly 7 Dwarf houses, though nobody provided canon proof).  What was NOT explained was why there were 9 Man rings?    If 9 was a meaningful amount, why? If it was merely "19-7-3" leftover, then why were there 19 total non-One rings made? When I set up a site in multiple languages, how should I set up my URLs for search engines and usability?  Let's say my site is www.example.com, and I'm translating into French and Spanish. What is best for usability and SEO?  Directory option:  http://www.example.com/sample.html http://www.example.com/fr/sample.html http://www.example.com/es/sample.html   Subdomain option:  http://www.example.com/sample.html http://fr.example.com/sample.html http://es.example.com/sample.html   Filename option:  http://www.example.com/sample.html http://www.example.com/sample.fr.html http://www.example.com/sample.es.html   Accept-Language header:  Or should I simply parse the  header and generate content server-side to suit that header?  Is there another way to do this? If the different language versions don't have different urls, what do I do about the search engines?    UPDATE 2011-12-06  Google has new recommendations for meta tags for explicitly pointing to other language content: .  UPDATE 2012-05-25  Related but not precisely:   UPDATE 2013-06-12  includes discussion of several URL schemes directly relevant to the question. How to count the node a user has created in a View? Disable auto-opening nautilus window after auto-mount Every time I plug a USB stick in, nautilus opens a new window with the contents of the drive. I would like to disable this auto-opening of the nautilus window, but I would like the actual auto-mount to keep working. Is this possible? How do I add a custom keybind to a button on any website? Proving an integral equation.