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…
Continue Reading »
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. …
Continue Reading »