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 » Maintenance » Transaction log » Backup   (RSS)
  • 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
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement