Technology Mania
  • Home
  • PCs,Laptops,Tablets
  • Smart Phones Reviews
  • IT learning
  • Webinars
  • Contact Us

Monday, October 31, 2016

Azure SQL Database Now Supports Backup Retention for 10 Years


 By Luke Jones - 
October 31, 2016 9:27 pm CET 


Microsoft announced that the backup retention of Azure SQL Database has been significantly increased. The service will also make automatic weekly backups of all databases.

Azure SQL Database now support up to 10 years of Backup Retention, says Microsoft. The announcement was made on the company’s official Azure blog. Principal Program Manager of Azure SQL Database, Alexander Noscov, said the change makes it easier for customers.

This ease of use means customers can enable long-term retention in a few clicks. With this new feature you can extend the retention period from 35 days to as much as 10 year. That’s quite a difference for sure. Azure SQL Database now also supports backups that are stored within the Azure Backup Service Vault.


To support data retention requirements, Azure SQL Database now backs up more often. Indeed, Microsoft says the service will create a full backup every week for each database.

In the blog post, Noscov explains how the backups work:

“Once you add the LTR policy to a database using Azure Portal or API, these weekly backups will be automatically copied to your own Azure Backup Service Vault. If your databases are encrypted with TDE, that’s no problem — the backups are automatically encrypted at rest.


The Services Vault will automatically delete your expired backups based on their timestamp, so there’s no need to manage the backup schedule or worry about the cleanup of the old files. The following diagram shows how to add LTR policy in the Portal.”
Azure SQL Database Temporal Tables

At the start of this month, Microsoft introduced Temporal Tables to Azure SQL Database. The service allows customers to track their data history easily. Some of the uses for these tables include:
Supporting data auditing in your applications
Analyzing trends or detect anomalies over time
Easily implementing slowly changing dimension pattern
Performing fine-grained row repairs in case of accidental data errors made by humans or applications
Posted by mohaghaly at 2:40 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: 10 Years, API, Azure, Azure Portal, Backup, database, Noscov, now, official Azure blog, Retention, SQL, Supports

1 comment:

  1. BloggerJanuary 6, 2017 at 1:39 PM

    Did you know you can shorten your urls with Shortest and earn money for every visitor to your shortened urls.

    ReplyDelete
    Replies
      Reply
Add comment
Load more...

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
Related Posts Plugin for WordPress, Blogger...

Popular Posts

  • Petya virus – is it ransomware and which companies have been hit by the global cyber attack?
  • AWS vs Azure vs Google Cloud Platform – Compute
  • AWS Snowmobile – Move Exabytes of Data to the Cloud in Weeks
  • Microsoft joining the Linux Foundation comes down to one word: Cloud
  • New MacOS Malware, Signed With Legit Apple ID, Found Spying On HTTPS Traffic
  • Diwali 2016: Here are some not-so-common but interesting gifts you can get this festive season
  • Google cracks the whip on fake reviews, ratings on Play Store
  • McAfee suggests about 2.5 million IoT devices were infected in Q4 of 2016
  • What is the difference between Docker, LXD, and LXC
  • Technology Mania : all security reports and analytics about wanacry ransom-ware

Blog Archive

  • Jul 09 (1)
  • Jul 08 (1)
  • Jun 30 (1)
  • May 16 (1)
  • May 02 (9)
  • Apr 25 (9)
  • Apr 21 (9)
  • Apr 14 (12)
  • Apr 12 (12)
  • Apr 10 (11)
  • Apr 05 (9)
  • Apr 04 (11)
  • Apr 03 (10)
  • Apr 01 (7)
  • Mar 24 (9)
  • Mar 21 (8)
  • Mar 10 (7)
  • Mar 01 (5)
  • Feb 28 (13)
  • Feb 18 (11)
  • Feb 09 (11)
  • Jan 31 (10)
  • Jan 29 (6)
  • Jan 25 (9)
  • Jan 14 (7)
  • Jan 12 (13)
  • Jan 09 (8)
  • Jan 06 (8)
  • Dec 30 (12)
  • Dec 24 (4)
  • Dec 23 (10)
  • Dec 20 (9)
  • Dec 17 (1)
  • Dec 15 (10)
  • Dec 14 (8)
  • Dec 13 (6)
  • Dec 12 (6)
  • Dec 10 (10)
  • Dec 08 (10)
  • Dec 03 (8)
  • Dec 01 (9)
  • Nov 30 (12)
  • Nov 27 (9)
  • Nov 26 (19)
  • Nov 16 (13)
  • Nov 15 (10)
  • Nov 14 (5)
  • Nov 12 (1)
  • Nov 11 (11)
  • Nov 10 (10)
  • Nov 09 (10)
  • Nov 08 (2)
  • Nov 07 (18)
  • Nov 06 (15)
  • Nov 04 (16)
  • Nov 03 (3)
  • Nov 02 (5)
  • Nov 01 (37)
  • Oct 31 (17)
  • Oct 29 (7)
  • Oct 28 (17)
  • Oct 27 (20)
  • Oct 26 (1)
  • Oct 24 (19)
  • Oct 22 (18)
  • Oct 19 (29)
  • Oct 17 (16)
  • Oct 16 (21)
  • Oct 15 (15)
  • Oct 12 (9)
  • Oct 11 (27)
  • Oct 10 (1)
  • Oct 07 (8)
  • Oct 06 (31)
  • Oct 05 (23)
  • Oct 04 (54)
  • Oct 03 (21)
  • Oct 02 (20)
  • Oct 01 (14)
  • Sep 30 (23)
  • Sep 29 (30)
  • Sep 28 (5)
  • Sep 27 (37)
  • Sep 23 (18)
  • Sep 22 (9)

Search This Blog

Feedjit

About Me

mohaghaly
View my complete profile

Tech Mania Facebook Page

Technology mania

Social sharing

visitors count

Copyright © 2016 by ghaly-DeV. Picture Window theme. Powered by Blogger.