I am new bee for SQL Server dba. I need some suggestion to shrink the database log file.  I have tried and found some solution to shrink the file. But i think this is not opted solution for this.  Solution 1:  ALTER DATABASE nologtest2 SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (nologtest2_log, 1); GO -- Reset the database recovery model. ALTER DATABASE nologtest2 SET RECOVERY FULL;   I am not sure I can do this in production.  Solution 2:    Backup log nologtest2 to disk='C:\MAS\nologtest32_log.trn'   DBCC SHRINKFILE (nologtest2_log, 1);   We can took some transaction log backup and then we can shrink the database. But i believe  it will break the lsn chain. Then we may face some issue in logshipping environment.  I need some very opted solution for reduce the database log file issues.  Note:   I am not very familiar with being a SQL Server dba. If i am ask anything wrong or understandingly please correct me.
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?
why can't i select two objects in edit mode?     I am trying to make a face from two different meshes but can't perform the action 6-digit password - a special decoding method Find the angle ADE of the given triangle. Given :  Angle ABE = 50, Angle DAC = 20, Angle BAD = 60, Angle ACB = 20 and Side CD = Side DA.Unit of angle values given is degree.  Find : Angle ADE.    I'm stuck and I need help here. Can't delete folder in Windows 7 I'm trying to delete a folder in Windows 7 and get a perplexing error message: "Could not find this item:  This is no longer located in G:\Graphics.  Verify the item's location and try again.  I can see the folder -- I can find it.  I just can't delete it.    I also get a second error message (sometimes) when I click on the folder: G:\Graphics 2009-11-17 refers to a location that is unavailable...this information might have been moved to a different location.    I'm using Windows 7; this folder is on an external hard drive.  I've emptied the folder (there were items in it); I've scanned that external hard drive for errors.  Trying to rename the folder yields the same enigmatic error message.    Is there a way to delete this folder? Present and future of bots on Stack Exchange There are discussions on Meta already for some time now about the potential usage of bots on Stack Exchange (SE). The earliest I could find goes back to  , but there have been others , .  Here’s an  about having a bot that tries to answer “easy” questions. The scenario is that (almost) duplicate, simple questions are asked time after time, despite SE’s efforts to prevent this by listing related questions at posting time. This is where the bot could be of service: it could quickly retrieve and post an answer from a previous duplicate (or with smarter Artificial Intelligence - AI)  even from elsewhere on the web, like a user manual or a mailing list discussion). I imagine this might save some review time for moderators, and perhaps users would also enjoy not having to answer over and over again to the same question. Besides, answers would be very fast, which should make everyone happy if they are also of good quality.  This idea of “janitor” bots can have more use cases besides answering “easy” questions (see also discussion ), like suggesting missing tags and re-formatting what should have been code blocks, to name a few.  Yet, despite a long time since these discussions, better Machine Learning Classifiers (ML) and AI over the years, and   , it doesn’t seem that any such bots are among us (except maybe ). As part of a research project at the university, I am trying to understand why this is the case.  For this reason I’d like your opinion on the following:   Do you consider a bot “harmful” for the SE communities?   If yes, would you consider the bot harmful even if   it operates in an automatic manner only in limited scenarios (e.g. specific tags) it operates in a semi-automatic manner (namely with the supervision of a moderator who decides for posting or not the answer).  it operates only for a limited amount of time in a small community (e.g. here).   Would you consider it too risky to give a bot a try? Would you accept an answer provided by a bot?   If not, why ? (e.g. you don’t trust replies from machines)  Would you consider useless a “sloppy” answer by a bot, even if it is provided in just a few seconds? Answers may be not perfect, but they may link to other relevant threads that can help the asker to fix the problem without waiting extra time for a human response. Does the shebang determine the shell which runs the script? This may be a silly question, but I ask it still. If I have declared a shebang  #!/bin/bash    in the beginning of my_shell_script.sh, so do I always have to invoke this script using bash  [my@comp]$bash my_shell_script.sh   or can I use e.g.  [my@comp]$sh my_shell_script.sh   and my script determines the running shell using the shebang? Is it the same happening with ksh shell? I'm using AIX. Prove the divisibility test by $7,11,13$ for numbers more than six digits What is the difference between "gerund" and "infinitive"? What is the difference between "gerund" and "infinitive"? I do not understand the differences.Can you explain them? How can I solve "Be aware that removing the lock file is not a solution and may break your system"? How to test that Apex Batch finish() sends an email? I have a Batch class that sends an Email from its finish method and want to test that. a But....I cannot test it. The the above test fails as there was no email invocation at all. BUT: I see it in the Limits view of my Dev Console that indeed one email invocation happens. Why?!  The batch class:  public MyBatch implements Database.Batchable&lt;SObject&gt; {      ...      public void finish(Database.BatchableContext context) {         sendEmail();     } }   The test method:  @isTest private static void sendsEmailOnFinish() {      Test.startTest();        MyBatch b = new MyBatch();     Database.executeBatch(b);     Test.stopTest();       // Verify     System.assertEquals(1, Limits.getEmailInvocations()); }   I thought this might be connected to using Test.startTest() and stopTest() but even moving the assertEquals before the Test.stopTest() doesn't make my test run. If $f_n$ converges to $f$ in $L^1$ and $g_n$ converges to $g$ in $L^1$. Does it necessarily mean that $f_ng_n$ converges to $fg$ in $L^1$ for finite measure spaces. Search and download audio-only from youtube Is there a way to search and then download from YouTube, with the situation that I only need to download the audio only, not the video. What is the cardinality of the set of the empty set? When should I begin publishing? Is a 1st-level spell cast using a 4th-level slot a 1st-level spell, or a 4th-level spell? Can I disown my heir? Everything was perfect. I have a good and young ruler, who has passed on some good genes to his sons. I also had a lot of spare lands, so I could make my heir a duke and doubly count when he came of age.  My mistake was to marry him off to some scheming wench. I knew it would end like this, but her stats were just too great to resist!  Anyway, a few years down the road, and my trusty spy master lets me know that my beloved son is looking to usurp me. Not cool! I demand that he end the plot, and decide to see how this develops.  Shortly thereafter, he suddenly dies (not by my hand — likely the wife is the culprit). My second eldest son becomes my new heir and favourite, however all the titles are inherited by my clubfooted grand daughter aged two. Curses!  Now, what I really wanted, was to imprison and disown my traitorous son followed by swift justice of the axe. Not sure what my other vassals would think of that idea, but I had a just reason for imprisonment at least.  Option number two, is to start plotting for my dearly beloved grand daughters untimely demise, but I'm not sure how that would work out either.  The situation is this. I'm young (40ish) and well-liked. I have a new heir, but I'd prefer to keep my lands for myself and give him the ones of the previous heir — one duchy and two counties currently held by my grand daughter. The duchy can be revoked free of charge, as I hold a claim to it. She has no siblings. I am da King. I have limited crown authority, but can bump it up to medium if it suits me.    So my questions to you are as follows:   Is it possible to disown a son, considering I have just cause for imprisonment? An execution would of course settle the deal, but my other vassals would probably find me "cruel". Is it possible to plot against a character which is not yet of age? What would happen if she suddenly died with no heir? Would all her titles be returned to the king or duke (i.e. me)?   EPILOGUE I had savegames before and after, so I decided to test a few things.   I could imprison my quisling of a son. I could also seize all his titles and banish him from my lands, but he would remain an heir, even if he wasn't officially a prince. I guess I could have let him rot in jail, as it seems prisoners often die in custody, but it would be a risky bet. After the unfortunate death of my old heir, it seems some strange rules apply regarding the remaining titles. The dukal title I could simply revoke for free (although at a opinion penalty from the duchess). Should she die today, one of the counties would be inherited by her younger sister, and the other would be inherited by me.   I found this to be an interesting development: Turns out my new heirs wife suddenly died. Who did he marry, other than the same scheming hag who presumably killed off his brother, and made an attempt at me? By a suspicious coincidence, I died not very long after. Such is the effects of the deceitful and ambitious traits combined with a really dope intrigue stat. ;) Why are text format commands used inside braces? Most commands in Latex are written with the arguments inside braces following the command: \command{arguments}. But text formatting options, like \em, or \scriptsize are usually written inside the braces, like {\em some italicised text}. Why is this? What makes these commands different? I'm particularly asking because it seems to make standardisation - of which LaTeX really appears badly in need - more difficult. Yield return from a try/catch block Limit of $\frac{\log(n!)}{n\log(n)}$ as $n\to\infty$. I can't seem to find a good way to solve this.  I tried using L'Hopitals, but the derivative of $\log(n!)$ is really ugly. I know that the answer is 1, but I do not know why the answer is one.  Any simple way to go about this? Prove or Disprove the Existence of Solutions...