In an earlier blog entry, I talked about “Deprecated” code and I highlighted the fact that the BACKUP LOG WITH NO_LOG and BACKUP LOG WITH TRUNCATE_ONLY statements are no longer allowed in SQL Server ...

Hello,<BR><BR>I have a few databases on a MSSQL 2005 server that where reloaded from backups from a SQL 2000 server a few month ago.<BR><BR>Today, I noticed that these databases had a strange "status" ...

There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated data (.mdf) file is at the size it should be when ...