Database Solutions

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 »

What to Do If Your SQL Server Database Misses Key

If your database is missing a master key, service broker will try to access it and will throw errors in SQL Server Error log. In this article, lets learn how to verify keys in your database and how to install keys if they are missing. Entry in SQL Server Error log: If your SQL Server error log has entries as mentioned below, then the target database is missing its master key. Service Broker needs to access the master key in the database '%.*ls'. Error code:%d. The master key has to...

Read more »