Category: sql server

Tip: RECOVERY_PENDING is not the same as RECOVERING

I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating. RECOVERY_PENDING is very different from RECOVERING. Definitions RECOVERING means that things are happening, and all may be well. “Database is being recovered. The recovering process is a transient state; the database will automatically become online if […]

SQL Sins and Powershell scripts, from another lovely #SQLSatOKC

Hi-ho there, Jen the DBA here. We spent a lovely weekend in balmy (99F and 30% humidity) Moore, Oklahoma for SQL Saturday #309. On Friday, Sean and I gave our “Become an Enterprise DBA” precon, and had dinner with the natives. Thanks again, OKC UG, for the dinner and beer! Friday night we had our […]