DB Backup in Azure VM

backupDB_to_NAS.jpgIf you are using the SQL Express version in your Azure VM then you need to take regular backups in the VM for your SQL DB. This article will help you to understand how to do it.

In SQL Standard version or higher we can use SQL Agent to configure a job to generate the DB backup. But if you are using Express version of SQL then you cannot use SQL Agent instead you can use any alternate method to generate the SQL DB backups.

The following method shows how we can generate DB backups using a bat file configured in Windows Task Scheduler using a Stored Procedure.

Read full article

Advertisements

Technical Lead for Microsoft Technologies especially in Azure, ASP.Net and in Angular JS.

Posted in Azure

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s