File Recovery

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 »

How and When to Use Quotation Marks In MS Access

Both users and developers at times use Quotation Marks while working with Access database. In this article we will learn such use case scenarios in detail. MS Access developers have regularly used Quotation marks for several purposes including most notably in SQL statements. Let look at some key situations where you need to use Quotation Marks: When a user wants to specify criteria for any domain aggregate function. When specifying or using criteria for Find method. When the user...

Read more »

4 Vital Steps in Logical Data Recovery on Hard Drive

If your hard drive is subject to data loss due to logical failures, like power outages, system crashes or viruses, etc., you will proceed to attempt logical data recovery. In this article, we will reveal the 4 essential steps in this process. Unlike physical data recovery, logical data recovery doesn’t involve any repairs on physical or mechanical components. It only focuses on logical problems. Issues like viruses, deletion, file system corruption, file structure damage and mistaken drive...

Read more »