Database Recovery

How to Set up an Always On Availability Group in SQL Server 2016

In this article, we look at the process setting up an Always On Availability Group in SQL Server Standard Edition in a stepwise manner. With the coming of AlwaysOn Availability Groups in the Standard Edition of SQL Server 2016, the deprecated feature of Database Mirroring will be replaced. The Standard Edition of 2016 supports Basic Availability Groups, which is another name for the AlwaysOn Availability groups in the Enterprise edition. Although setting up Basic Availability Groups is very...

Read more »

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 »