Database Recovery

3 Alternatives to Object Level Recovery in SQL Server

In this article, we explore possible alternates to an object level recovery run in SQL Server. Databases stored in SQL Server are often very large and heavy files. If one needs to restore only one table from the whole database, then restoring the whole database does not make sense. It will not only take up too much time, but also resources. The Object Level Recovery or Table Level Recovery was one feature in SQL Server which could be used for restoring just a single table, but the feature...

Read more »

5 Most Important Points for SQL Server Backup

Organizations need to make sure their backup process for SQL Server databases are as through as possible. In this article we offer you a checklist that will go a long way in making your backups effective. We cannot stress enough on the importance of backups in SQL Server. For the backup process, it is not only important to do them, but also to do them right, to store them right, and to use them right. Backups in SQL Server might seem like just another important, regular process, but it is...

Read more »

How Always On Availability Groups Make DBAs Take A Close Look At System Admin Functions

In this article, we take a look at how Always On Availability group has changed the priority for DBAs and have induced them to keep an eye on System Admin functions With the coming of Always On Availability Groups in the 2012 edition of SQL Server, the System Administrator roles were bound to change, and this made all the DBAs a lot more concerned about their existing sys admin roles. The AlwaysOn Availability Groups feature is a feature that provides disaster recovery option, along with...

Read more »