How to Attach a SQL Server Database without a Transaction Log and with Open Transactions

You want to attach a SQL Server database that does not have the transaction log files and get the following error: "The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure." In this tip I will help you to successfully attach the transaction log to the problematic SQL Server database.

Tempdb Default Size

Automate your Morning Checklist

A morning checklist is a good thing, but an automated one is better.

Partitioning Limits in SQL Server 2019

Verify your SQL Server database backups

Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]

Preparing Encryption with Trace Flags

Proactive Performance Tuning

Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.

Querying for Table Allocated Pages

How Bad are Bad Page Splits?

A look at bad page splits and how they affect your database.

Learn from the Troubles of Others

Learning from the pain of others can be valuable in your career.