THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » transaction log   (RSS)
Showing page 2 of 2 (18 total posts)
  • 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
  • Geek City: Reading the Transaction Log

    Sorry, I'm not actually going to tell you how to read the log. I'm just going to talk about it... and whether it's a good thing to be able to do or not, or whether it's an absolutely crucial feature that MS needs to provide for us immediately, in a hotfix, if not sooner. Forget about fixing bugs, I want to read the log because I forgot to set up a ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 23, 2008
Privacy Statement