Database Recovery

How Frequently You Should Run DBCC CHECKDB in SQL Server

In this article, we look at factors which a DBA considers before deciding the required frequency of running DBCC CHECKDB. While running SQL Server, corruption of database is the biggest fear of the DBA. And if that corruption is transported to the backups, it becomes even more problematic. To avoid corruption of databases from expanding, and becoming a part of your backups, it is important to regularly apply security checks to your databases. DBCC CHECKDB is one of the most preferred...

Read more »

How to Restore Individual Pages in SQL Server

In this article, we look at the concept of restoring pages in SQL Server instead of performing a file recovery. Many times, while using SQL Server databases, you might come across one of the pages in the application that is corrupt. When a page out of the complete database is corrupt, there is no need of restoring the whole database, you can simply restore the corrupted page. For restoring corrupted pages in SQL Server, you can either make use of the SQL Server Management Studio (SSMS), or T...

Read more »

What is Simple Recovery Model and When You Should Use it in SQL Server

In this article, we look at a simple recovery model which incidentally does not include log backups. A Full Recovery Model which does not make use of log backups is called a Simple Recovery Model. A Simple Recovery Model forms the most basic recovery model available in SQL Server. All the recovery models that SQL allows the users access to, are based on maintenance of transaction log, the feature in the application that decides how the transactions are logged, is the Recovery Model...

Read more »