SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

As mentioned in my post on VLDBs, one of the key pieces of a high performing solution is the use of Read-only Filegroups. If a significant part of your data is not changing, then why not tell SQL ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...

I have a SQL server that is freezing IO on all DBs 6 times per day at about 2am, 6am, 10am, 2pm, 6pm, and 10pm. These only freeze IO for approximately 2 seconds each time, but it is long enough that ...

So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...