Database Recovery

How to Auto Track Deleted Databases in SQL Server

Using SQL Server's Schema Changes History we can identify the name of databases that were dropped from the SQL Server. In a big SQL Server environment, connecting to each Schema Changes History of every SQL Server instance is a very difficult task. In this article, we will learn how to automatically track deleted databases. Multi options There are several options with which you can track a database getting deleted from your SQL Server instance. Option1: Log data from the system table...

Read more »

How to Use LOG backup to Find Deleted Objects in SQL Server

In this article, we will learn how to use SQL Server Transaction Log backup files and identify  1) Name of objects that were deleted from the database  2) The User who deleted the database objects SQL Server does not support object-level restore. So, to restore the deleted object, you must restore the entire database with different name and then import the deleted object into the original database. Step by Step Step 1: Create a database and add some tables. As it is just a demo,...

Read more »

How to Auto Maintain Database Emails in SQL Server

If the Database Mail in your SQL Server is used extensively, all messages and attachments from those emails would be saved in the MSDB database. Eventually, MSDB database will grow in size and occupy more disk space. This will also increase the time taken to complete backup of system databases. In this article, we will learn how to automate the maintenance of SQL Server database email Using system stored procedures For this automation, we would be using sysmail_delete_mailitems_sp. It is SQL...

Read more »