Over the years I’ve been called in to work with numerous clients that were hit with ransomware. Even the times that the customer paid the ransom to unlock their encrypted files, there were still issues. Often times there were still issues with the files where they will not restore or data/log files can’t attach to […]
Tag: sql server
SQL Server Error 9002 – Full Transaction Log
A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else not allowing the log to truncate. I often find Change Data Capture enabled and the jobs not running, SQL Server Replication in place and replication not […]
SQL Best Practices
SQL Server has evolved a great deal since I first started working with SQL Server 6.5 in 1998. Unfortunately I continually come across newer systems that are configured with old ‘best practices’. Things like 1 tempdb file per core, 1 core per socket on VMware machines, index rebuilds each night, and more. Below are some […]
Why You Need a SQL DBA or Consultant
Many organizations do not have in-house DBAs. This can be due to a number of reasons. Most commonly it is smaller organizations that cannot justify a full time DBA. Others are larger organizations that do more development work or organizations that run a lot of vendor supported software that don’t understand the value of having […]
Risk with Not Patching and Upgrading SQL Server
Working with SQL Server over the past 25 years for various organizations all over the world, I usually always find a database server that is well outside of support. I’d be willing to be that anyone reading this blog post in 2024 knows of a SQL 2000 or SQL 2005 instance out there. I hear […]
Purging SQL Server Backup History
It seems like every few weeks I come across a database server with a very large msdb. After a small amount of investigation work, I determine that the largest tables consuming the most space are all related to backup history. I typically only keep 30 days of backup history but I’ve seen as little as […]
Why Test SQL Server Backups
For a lot of us data professional types, this seems like a silly topic, however I constantly hear of companies that aren’t testing their backups by restoring them, or don’t have proper backups at all.
There Is Insufficient Free Space on Disk Volume To Create the Database
I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have access to both environments, it is very easy to evaluate and clean up any issues with the source databases. In situations where you are only provided […]