THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Transaction Log   (RSS)
Showing page 2 of 3 (21 total posts)
  • Why we never want to trick SQL Server into rebuilding a log file

    ''Never'' is a strong word, so let me say that we really really want to avoid it, if at all humanly possible. In short, we will have a (potentially) broken database, both at the physical level and at the logical level. Read on. Just to be clear, when I refer to a ''log file'' here, I'm talking about a transaction log file, an .ldf file. Ever so ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 14, 2010
  • Restore database to the point of disaster

    This is really basic, but so often overlooked and misunderstood. Basically, we have a database, and something goes south. Can we restore all the way up to that point? I.e., even if the last backup (db or log) is earlier than the disaster? Yes, of course we can (unless for more extreme cases, read on), but many don't realize/do that, for some ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 27, 2010
  • Are log records removed from ldf file for rollbacks?

    Seems like a simple enough question, right? This question (but more targeted, read on) was raised in an MCT forum. While the discussion was on-going and and I tried to come up with answers, I realized that this question are really several questions. First, what is a rollback? I can see three different types of rollbacks (there might be more, of ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 22, 2010
  • Geek City: Exploring the Transaction Log Structure

    As I mentioned last October, my PASS preconference seminar was a whole day about the transaction log. I told the attendees all kinds of things about the structure of the log, and told them about one of the best tools for exploring the structure: the command DBCC LOGINFO. This command is officially undocumented, but numerous bloggers have discussed ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 21, 2009
  • Do you perform log backup for the model database?

    Are you stupid, you might think... But stop and think for a while. Model is no different from other databases. And by default it is in full recovery model. So as soon as you do your first database backup (you do backup your system databases, right?) the log for model will start filling up and autogrow. ''But, hey, I don't do any modifications in ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 18, 2009
  • Will EMPTYFILE on primary ldf "doom" it somehow?

    I just read a newgroup question whether doing SHRINKFILE with the EMPTYFILE option for the primary log file somehow cause ill effects. Shrinkfile for the ldf will not move any data (log records) or so. For an ldf file it is basically a preparation to tell the engine that you are about to remove this file (ALTER DATABASE ... REMOVE FILE). Now, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 29, 2009
  • Geek City: 24 hours of SQL Server!

    I know, my Geek City posts are usually really technical, but I figured it’s only Geeks who are going to want a solid 24 hours of SQL Server presentations… so this post is dedicated to all the SQL Server Geeks out there! I will be presenting as part of 24 hours of PASS, on September 2. You can read about my session (“What’s Simple about Simple ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 13, 2009
  • Table restore and filegroups

    The story usually goes something like: Q - How can I restore only this table?A - Put it on its own filegroup and you can do filegroup level backup and restore. The problem with above answer is that it most likely misses the point. We need to ask ourselves:Why do you want to do a table level restore? The answer to the question is very ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 25, 2009
  • Remove transaction log files

    Say you happened to get too many transaction log (ldf) files. Can you remove log files from the database? Yes, but only if a file isn't in use, and you cannot remove the first (''primary'') log file. So, be prepared to investigate the virtual file layout, using DBCC LOGINFO, to see if a log file is in use or not. You can find information ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 17, 2009
  • Geek City: When is FULL Recovery not Really FULL Recovery

    You may think that having a database set to FULL Recovery Model means that your database can be fully recovered. The key word in that previous sentence is 'can'. It is possible to fully recovery a database in FULL recovery, or to restore it to an arbitrary point in time, or up to the point of a system failure, IF you have been a good DBA and you ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 30, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement