How to configure Log Shipping using two instances Step by Step

Log Shipping

The backup compression feature was introduced in SQL Server 2008 Enterprise edition.

Configuration of Log shipping involves 3 jobs they are:

Log Backup job:

Log backups of the database are taken at regular intervals according to the specified and are saved in the Source folder of the Primary Instance/Server.

Read more

How to Configure Mail Alerts for SQL Server Job Failures

Alerting  the Admin for SQL Server Scheduled Job failure involves the following Configurations

==> Configure Database Mail.
==> Create a SQL Server job.
==> Configure Alert system in SQL Server Agent properties
==> Create an Operator.
==> Adjust the SQL Server job to send on Failure.

Read more

How to import data using import and export wizard in SQL Server

Step-1: Open SQL Server Management Studio, connect to an instance.

Step-2: Expand databases & select the respective database to initiate the import process.

Step-3: Right click on that database and click on Import data. And then click "Next".

Read more