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
Posted in Azure

Manage VM Size and Price

One of the main thing  while setting up a VM is its size and cost. This article will help you to understand how to configure the VM size and the costs involved for the configurations.

If you have already created a VM then you can change the size from the management portal using the below option.

VMSize.png

In the above case I have chosen the Size as D4_V2 which gives a 3.5GB Ram with 50GB HDD for a monthly bill of 119.78 USD. Similarly based on your production requirements you can choose to appropriate size.

 

Happy Programming.

Posted in Azure

Migrate Azure SQL DB to Native SQL Server

This article will help you to transfer your DB from Azure SQL Server to On-Premise SQL server.

Export Azure SQL Database

Connect to your Azure SQL from On-Premise SSMS

1

Choose menu Export Data-Tier Application from Tasks

2.png

You can see the below screen

3.png

Click on Next, and Save the ‘bacpac’ file to a convenient location.

4.png

Click Next to proceed and it will generate the bacpac file as showed below.

5.png

Click Finish and exit.

6.png

Import Azure SQL Database

Next step is to import the bacpac to Local SQL server.

Open SSMS and connect to your Local Server as below

7.png

After connecting choose Import Data-tier Application option

8.png

9.png

Click on Next and choose the ‘bacpac’ file you have created before. 10.png

Next it will show the .mdf and .ldf file locations. You can choose the convenient location from this option.

11.png

Click Next. this will restore the DB with data in your Local SQL server from Cloud.

12.png

13.png

Hope this article will help you to understand how you can move database from Azure to local SQL Server.

Happy Programming.

Posted in Azure

Azure World

The blog ‘Azure World’ is a small starting to share the knowledge to  my fellow developers. Whether you’re just starting out as a blogger, or just starting anything in life– hopefully this is proof that you can start from no where and the effort to learn will take you far.

 

Posted in Azure