The past two nights, our nightly index job has caused our log drive to fill up.   We complete log file backups every 15 minutes, and the log file still grew to 250GB.  This is a SQL Server 2008R2 SP3 instance.  Our DBCC LOGINFO shows 1500 rows, with all but 6 with a status of 2.  There are no open transactions.  (dbcc opentran) The wait_type_desc = 2 / Backup Log The database used to replicated, (long ago). Even ran the command to turn off replication.  However, completing a log backup does not seem to clear the VLFs.   The only way I've been able to clear is to convert the database to simple recovery and then shrink the logfile.   Which, obviously, this is not desirable.   I'm not sure where else to look.  Any help would be appreciated.
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?
How to edit geometry of multiple layers simultaneously in QGIS 3? I have several line layers (route, pipes, cables) that share the same geometry and would like to edit them simultaneously.   Is there a way to easily snap the geometry of the pipes and cables layers to the route layer so that I can simply change the geometry of the route layer and don't have to repeat all changes on the other two layers as well?  To clarify, I plan a fibreglass route and have three layers. The first one describes the route that I have to take to pass all homes that have to be connected. The second one contains the pipes in which the cables lie and the third layer is the cable layer. So all features on those layers have to have the same geometry. Once I change the pathway of the route layer, I have to apply the same changes to the other two layers to ensure that they are still aligned with the route layer. I'm not sure whether I understand your comments correctly, but I use the basic editing tools in QGIS 3. This is a homework question. $d,n\ge 2$.  Let $L=\{(x_1,...,x_n)\in (\mathbb{R}^d)^n: x_i\in \mathbb{R}^d,  x_i\ne x_j \forall i\ne j\}$.   I tend to think it is not path connected because if you assume $d=1$, this is the case. But I cannot prove for $d\ge 2$.  Any help will be appreciated! :) 101 positive integers placed on a circle A Pigeonhole Principle problem:     101 positive integers are placed on a circle whose sum is 300. Prove   that it is possible to choose from these numbers some consecutive   numbers whose sum is equal to 200.   (I don't know if the word 'consecutive' is appropriate in this case ,I mean that these numbers follow each other on that circle) Word for a temporary project name Good reasons to prohibit inheritance in Java? In the example below, an error is caused by \begin{align} and \end{align} but I do not see why:  \documentclass{book} \usepackage{amsmath} \newenvironment{subalign}{\begin{subequations}\begin{align}}{\end{align}\end{subequations}} \begin{document} \begin{subalign}      a&amp;=b\\     &amp;=b \end{subalign} \end{document} How do we prove $n^n \mid m^m \Rightarrow n \mid m$? I'm not sure I've got this right. When proving $a^n \mid b^n \Rightarrow a \mid b$, can we do this indirectly? In short,  "Suppose $a$ does not divide $b$, this implies that $a^n$ does not divide $b^n$. But $a^n \mid b^n$, hence $a$ divides $b$."  How about $n^n \mid m^m \Rightarrow n \mid m$? Can we do this the same way? What registers to save in the ARM C calling convention? It's been a while since I last coded arm assembler and I'm a little rusty on the details. If I call a C function from arm,  I only have to worry about saving r0-r3 and lr, right?  If the C function uses any other registers, is it responsible for saving those on the stack and restoring them? In other words, the compiler would generate code to do this for C functions.   For example if I use r10 in an assembler function, I don't have to push its value on the stack, or to memory, and pop/restore it after a C call, do I?  This is for arm-eabi-gcc 4.3.0. Copy maintenance plans to a different server Is there a way to copy maintenance plans from one SQL Server 2012 to another? Both servers are not accessible via the same copy of Management Studio at the same time (on different networks). How do I replace multiple spaces with a single space in C#? How can I replace multiple spaces in a string with only one space in C#?  Example:  1 2 3  4    5   would be:  1 2 3 4 5 Remove Meta Privilege for MSE (only) Mobile web refresher, part 3 Memory layout of a .NET array What is the memory layout of a .NET array?  Take for instance this array:  Int32[] x = new Int32[10];   I understand that the bulk of the array is like this:  0000111122223333444455556666777788889999   Where each character is one byte, and the digits corresponds to indices into the array.  Additionally, I know that there is a type reference, and a syncblock-index for all objects, so the above can be adjusted to this:  ttttssss0000111122223333444455556666777788889999         ^         +- object reference points here   Additionally, the length of the array needs to be stored, so perhaps this is more correct:  ttttssssllll0000111122223333444455556666777788889999         ^         +- object reference points here   Is this complete? Are there more data in an array?  The reason I'm asking is that we're trying to estimate how much memory a couple of different in-memory representations of a rather large data corpus will take and the size of the arrays varies quite a bit, so the overhead might have a large impact in one solution, but perhaps not so much in the other.  So basically, for an array, how much overhead is there, that is basically my question.  And before the arrays are bad squad wakes up, this part of the solution is a static build-once-reference-often type of thing so using growable lists is not necessary here. K&R Exercise 1.16 - Limitation on line length How do you pass a member function pointer? I am trying to pass a member function within a class to a function that takes a member function class pointer.  The problem I am having is that I am not sure how to properly do this within the class using the this pointer.  Does anyone have suggestions?  Here is a copy of the class that is passing the member function:  class testMenu : public MenuScreen{ public:  bool draw;  MenuButton&lt;testMenu&gt; x;  testMenu():MenuScreen("testMenu"){     x.SetButton(100,100,TEXT("buttonNormal.png"),TEXT("buttonHover.png"),TEXT("buttonPressed.png"),100,40,&amp;this-&gt;test2);      draw = false; }  void test2(){     draw = true; } };   The function x.SetButton(...) is contained in another class, where "object" is a template.  void SetButton(int xPos, int yPos, LPCWSTR normalFilePath, LPCWSTR hoverFilePath, LPCWSTR pressedFilePath, int Width, int Height, void (object::*ButtonFunc)()) {      BUTTON::SetButton(xPos, yPos, normalFilePath, hoverFilePath, pressedFilePath, Width, Height);      this-&gt;ButtonFunc = &amp;ButtonFunc; }   If anyone has any advice on how I can properly send this function so that I can use it later. Ubuntu Server 20.04 Nvidia Driver Dependencies I had a hard time installing Nvidia drivers in a fresh install of Ubuntu 20.04.  Installing via sudo apt install nvidia-driver-430 resulted in a list of 542 packages to install.  I ended up spending a bit of manual effort to get the Nvidia-provided driver installed without nearly so many dependencies (only had to install gcc and make).  Is this massive number of dependencies normal for Ubuntu Server?  I did a very vanilla install without the GUI.  Reddit suggested I ask here, as their opinion is that I should just install from the default repos, but I felt that so many packages was absurd just to install a driver.  Edit for clarity: installing the nvidia-driver-430 package appears to install the entire Gnome shell, which I feel is unnecessary on a server. Unable to see anything after importing .obj file I try to import .obj files from this project:  - the files contain Polygon Mesh Data.  When I import the obj file into blender, the outliner shows a new mesh added, but nothing is visible in the 3D viewport:      Any help will be appreciated. Is there any way to view saved wifi passwords on the iPhone? What do you call a person who does/thinks the opposite of the crowd for just that reason? Is it possible to set the "urgent" flag in Gmail for outgoing mail? I'd like to be able to flag time-sensitive emails as such.