Author: Peter Whyte
-
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.
Written by
-
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.
Written by
-
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.
Written by
-
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.
Written by
-
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.
Written by
-
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.
Written by
-
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.
Written by
-
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…
Written by
-
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.
Written by
-
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.
Written by
- DBA Scripts: Get Log Shipping Status
- SQL Server Row-Level Security: The Filter Does Not Stop Cross-Tenant Writes
- View the Definition of a Stored Procedure in SQL Server
- TempDB Is Full or Still Growing: Find What Is Using It, Right Now
- SQL Server Service Will Not Start: Error 17113, 17058, 1067 and Where the Real Reason Is
- How to Move TempDB Files in SQL Server
- Backups & Recovery (17)
- DBA Scripts (152)
- High Availability (HA) (13)
- Installation & Configuration (49)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (20)
- Storage & Capacity (16)
- T-SQL Fundamentals (15)
- Troubleshooting (94)
- Wait Types (235)