I was in Phoenix last week to visit a customer, and I saw an email come through regarding a customer who contacted support because they discovered they were missing data from a table. The customer contacted support on Friday morning and our team was engaged almost immediately. The data loss had been discovered on Thursday…
Category Archives: Backups
A Successful Failure
Last week I dialed into a customer site to make some changes to their database. The customer wanted to alter the configuration of the application, and the application interface did not permit the change they wanted. Neither the dial in nor the change request was unusual; what was unusual was that I had to ask…
The Most Important Maintenance Task…
We had a customer lose their entire database this week. The server failed in some manner and they tried to recover the database from the disks, but they could not bring the database online. They engaged our group and we tried everything we could to no avail. Until now, the most data loss I had…
Bulk Logged Recovery Model and Point In Time Recovery
A couple weeks ago I spoke with a customer who was having problems with their index rebuilds after a SQL Server upgrade. The database is about 160 GB and they upgraded from SQL Server 2000 to SQL Server 2005. Since the upgrade, the index rebuilds have been failing because the transaction log is filling up. …
