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 »
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 »
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 »