SQL server shuts down or crashes in the middle of a transaction; Methods to Recover SQL Database from Suspect Mode. Below are some methods you can follow to get the database out of the suspect mode.

If you’ve the database backup available and know the time of data deletion, you can use the transaction log with Log Sequence Number (LSN) to recover the deleted data from SQL Server. However if you ...

Set up a swift alert using SQL Server Agent to notify you of potential SQL database corruption before it's too late to rectify. If you have an updated backup, you could restore the database using ...

As I have recently discovered though, you can use a PowerShell script to back up a SQL Server Express database. Before I show you how to perform such a backup, there are a few things that you ...

A client recently had a server lose two drives in it's RAID 5 array simultaneously. We were able to recover most of their data, but one database they needed has no backup since 1/10/09. After ...