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/Serve...

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 Failur...

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