Database Recovery

How to Keep Your SQL Server Log Simple & Clean

SQL Server Logs is the first place we search whenever there is an issue on SQL Server. Due to default settings, these logs also contain generic information which makes it very difficult for us to find important information. Since there is too much of data, we tend to miss the necessary information. In this article, we will learn how to keep SQL Server Logs clean and simple SQL Server Backup filling up SQL Server log It is a common scenario to see many databases hosted within a single SQL...

Read more »

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 »