Database Solutions

How to Prevent SQL Server Jobs from Getting Executed during Maintenance

In a big SQL environment, it is very common to see servers rebooted during maintenance. Though we might inform the users about the server maintenance, many DBAs miss taking care of their SQL Server agent jobs. In this article, we will learn how to identify SQL Server Agent jobs that are scheduled to run at a specific time. We can then disable jobs whose schedule collide with the maintenance window. No notification: You might have set up SQL Server jobs to send out failure notifications or...

Read more »

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 »