SQL DBA Blog: Home
-
SQL Server Agent Will Not Start, or “Agent XPs Component Is Turned Off” (Error 15281)
A greyed-out Agent node and a stopped Agent service are two different faults, and the sp_configure fix only cures one. One query tells them apart, then the Agent’s own log gives the reason.
-
Database Marked SUSPECT (Error 926): EMERGENCY, CHECKDB, or the Backup
A database comes back from a restart marked SUSPECT and error 926 refuses every connection. The real sequence: confirm the state, read the error log, then choose between EMERGENCY repair and the restore.
-
The Server Network Address Cannot Be Reached or Does Not Exist (Error 1418)
Error 1418 says the server network address cannot be reached and never says why. The error log names the fault, and then there are five checks in the order that finds it.
-
Set the Default Database for a SQL Server Login
One line sets a login default database, and SQL Server never checks that the login can actually use it. The failure arrives at the next connection, with the same message whether the database is gone or just inaccessible.
-
SQL Server High CPU: What to Check First, in Order
SQL Server at 100 percent CPU describes four different problems. The five checks that separate them, in the order that finds the fault fastest, each handing off to the script that does the work.
-
How to Export SQL Server Query Results to CSV
Exporting a query to CSV looks like a solved problem. Set a comma as the delimiter, save the file, done. Then somebody opens it in Excel, a column has shifted, and a customer called Smith, Jones and Co has quietly turned into two fields.
-
Cannot Connect to SQL Server: The Checks in the Order That Finds It
A network-related or instance-specific error, error 53, error 40, error 26: which one you have decides where to look. The connection checks in the order that finds the fault, each one linking to the full fix.
-
How to Rename a Computer That Hosts SQL Server
Renaming a Windows machine is a two minute job. Renaming a Windows machine that happens to be running SQL Server is not, because SQL Server records the server name in its own metadata at install time and does not notice when the operatin…
-
How to Import a CSV File into SQL Server
There are two ways to get a CSV into SQL Server, and picking the wrong one costs you either an afternoon or a silent data loss.
-
BACKUP LOG Cannot Be Performed Because There Is No Current Database Backup (Error 4214)
A log backup fails with Msg 4214 when a FULL recovery database has no log chain yet. One check finds it and one full backup fixes it.
- Cannot Connect to WMI Provider: SQL Server Configuration Manager Will Not Open
- SQL Server Configuration Manager: Where to Find It and What a DBA Uses It For
- DBA Scripts: Get Failed Login Summary
- Query Was Fast Yesterday, Slow Today: Find What Changed
- The Current Transaction Cannot Be Committed (Error 3930)
- Sort and Hash Spills to TempDB: Find the Query and Fix the Grant
- Backups & Recovery (17)
- DBA Scripts (154)
- High Availability (HA) (13)
- Installation & Configuration (58)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (23)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (235)