Azure SQL(PaaS): Geo-Replication (DR)

I have seen couple of scenario where most of the clients and customer really wants to go with SQL (PaaS) services but they are not moving because if an case SQL PaaS services got crashed due to some technical issue there was option to recover the services or fail back the services with limited time frame.

Now its possible through Geo replication where you can configure the secondary database in paired region and start the replication, When ever your SQL PaaS services are unavailable at that time you can click on the fail-over option and with your estimated time SQL Database will available for you .

Lets see how we can enable the Geo-Replication for Azure Services.

Step:1  Preparing for Geo Replications 

  • Please select the Azure SQL (PaaS) Database which we needs to have Geo-Replications .
  • Select the Region you wants to have your Database secondary region for replication, You can select more the 1 region but has to configured one at time.
  • Once you will select the region you are done with this steps.

SQL-13.jpg

Step:2 (a) -Secondary SQL server Details 

  • Select the Region you want to create the SQL DBs secondary site.
  • Database Name will be selected automatically.
  • Secondary site type is readable.
  • IF you have already configured the elastic pool then we will select the elastic pool.
  • Target server if you don’t have then create New Once (Provide the Name, SQL login Name and password)
  • click OK.
  • Select the pricing tire (Basic,Standard , Premium)
  • Click ok .

SQL-14

Step:2 (b) Pricing Tire Section based on you Current Database configuration.

SQL-15

Step:2 (C) Verification of Secondary Database site and click ok.

SQL-16

Step:3  SQL Secondary site creation. 

  • Once you will click on ok
  • Secondary site will star creating .
  • Once secondary site will be created , it will start replication of Database.
  • Once the Database replication is completed , you will get option for fail-over.

SQL-17

Step:4  Failover the SQL Database.

  • My Primary site is completed replicated to secondary site.
  • Now i want do a failover .
  • Click on the Forced Failover.
  • It will start the failover process.
  • Once it is completed you will the secondary database is active.
  • Once you are done with failover your activity is completed.

SQL-18

Advertisements

(10 Years):Azure SQL Database Long-term backup retention(Preview)

In my previous organization has asked me how can retain the Azure SQL (PasS) services Backup for 10 years and i was searching that option but didn’t get .

But now that is possible Through  Long-term backup retention(Preview) to retain your Azure SQL Database backup for 10 years with the backup vault that option is in Preview and lets how we can configure the Azure SQL Database backup for 10 years with recovery Vault  .

Step-1 :  Identification Of SQL Database 

  • Click on the SQL Database
  • Select the Azure SQL Server Name

SQL3

Step:2 Long Term Backup Retention Configuration.

  • Go to Settings
  • Select the Long Term Backup Retention Tab

SQL4

  • Select the Preview Items
  • Accept the term and Condition .
  • Select the Database you want retain more than 1 years.

SQL5

Step :3 Long Term Backup Configuration 

  • Select the Backup Recovery Vault if you have created
  • If you don’t have recovery Vault ,Please create one Recovery Vault.
  • Select the Backup Retention for 1 year to 10 Years.
  • Click on

SQL6

Save the Configuration and you SQL Database backup is configured for 10 years.

SQL7

SQL Backup is enabled for 10 years.

Azure SQL DBs Creation(Pass)

In this Blogs i will shearing my experience how to create the Azure SQL Serves and SQL Database , I have seen couple of scenarios where azure learners  has dought between On-premises SQL Servers and Azure SQL Server (Pass)  and so thought of create blogs to clear the understanding on this and show then how useful Azure Pass services are.

 

SQL Server (IAAS)

  • SQL server on Azure VMs or on-premises are same .We need to download and install the SQL servers from MS download center or MSDN superscription.
  • We need to maintain the SQL Server Licensing
  • We need to install and configure manually as that will take almost 1 to 2 hrs to get it installed and configured.
  • We need to backup Manually or schedule the Backup for Azure Databases.

Azure SQL Server (PAAS)

  • We can use this Services (DBaaS) Database as services
  • It’s backed by Software Define services which is called as SaaS.
  • Easy to take the backup in Azure
  • Easy to fail-over and replicate to another region.
  • Recover the DBs from backup.
  • Automatic Backup Scheduled
  • Cost is much lower then Azure SQL On-premises
  • Advance Security Feature

Azure SQL DBs Creation

Step-1 Prerequisites

  • Azure SQL DBs Name
  • Azure SQL Configuration
  • Region
  • SQL Server Name
  • SQL server user Name and passwords
  • Select ok
  • Create the SQL Servers DBS.

SQL1.jpg

Your Azure SQL Database is created you can check that SQL Database in azure Resources.