SQL Server Database Recovery

Do’s and Don’ts of SQL Server Programming

May be you are just getting started with learning SQL server programming. May be you are facing some performance related issues. Or, perhaps you just like learning new stuff.  Regardless, you will find this post insightful on the do’s and don’ts of SQL Server programming and maintenance. If you follow these dos and don’ts religiously, you can greatly enhance the performance of your SQL Server.  Other than that, it’s always good to have some tips handy, for you never know when you...

Read more »

Why Backups are Essential to Recover from SQL Server Database Disasters

In this article, we will first discuss why regular backups are so important for SQL Server database disaster recovery. Then we will introduce the way to keep backups in good conditions and how to respond to database corruptions. SQL Server Database Disaster One should know that disasters related to SQL database management are highly unpredictable. What’s more, you cannot avoid them from happening. The best you can do is stay prepared for the worst situations. That’s why the best measure...

Read more »

How to Fix Damaged MDF and LDF files in SQL Server

This post is intended to explain the importance and functionalities of MDF and LDF file in an SQL Server, along with common reasons due to which they go corrupt. The section further discusses ways to repair these damaged files. Introduction of SQL Server Files SQL Server by Microsoft is a database management system. The system stores and helps retrieve data as and when requested by other applications. There are mainly three files in this server namely – MDF, NDF, and LDF. First two files...

Read more »