Sunday, December 31, 2017

Azure SQL Database - Backup

Most of you must be knowing that backup in Azure SQL Database fully automatic. After the database is created and the database is automatically backed up by Azure. One can restore to any point in time for a period of 7 days for the basic subscription and 35 days for standard and premium.

Most of the above are already known to you. But, what can be little surprising for someone learning Azure SQL Database is, one can never access backup files used for recovering the database. Meaning, you can only restore the database as another azure sql database but you can never download the automatic backup files like you would do when you configure backups on your on-premise database.

So, what do you do when you need the backup file of Azure SQL Database for reference?

Create a bacpac file backup (similar to your full back up on - premise database ) of Azure SQL Database


1) Connect to the Azure SQL Database via SSMS
2) Right click tasks-> Export -Data-Tier Application. Follow the screenshots below to manually take a backup of Azure SQL Database




So, if you need an older backup of the azure database (yesterday 8:00 am backup), then recover the older version of the database using the Azure portal to a different azure sql database and extract the bacpac file using the steps explained above.

20 comments:

play school in hyderabad said...

Nice Post for this blog
Sanjary kids is the best playschool, preschool in Hyderabad, India. Start your play school,preschool in Hyderabad with sanjary kids. Sanjary kids provides programs like Play group,Nursery,Junior KG,Serior KG,and Teacher Training Program.
play school in hyderabad, India
Preschool in hyderabad, India
Preschool teacher training course in hyderabad, India
pre and primary teacher training course in hyderabad,India
early childhood teacher training course in hyderabad, India

piping design course said...

Nice information
We are the best piping design course in Hyderabad, India. Sanjary academy Offers Piping Design Course and Best Piping Design Training Institute in Hyderabad. Piping Design Institute in India Piping Design Engineering.
Piping Design Course
Piping Design Course in india
Piping Design Course in hyderabad

Bhanu Sree said...
This comment has been removed by the author.
Bhanu Sree said...

its a great article on your blog. Thank you for sharing.
SQL Azure Online Training
Azure SQL Training
SQL Azure Training

TNK Design Desk said...

Very useful and informative blog. Thank you so much for these kinds of informative blogs.
who provides seo services, web development services, logo design services, graphic design ,
digital markeing and all kind of web design, development and digital marketing services.
best website design services in gurgaon
web company in delhi
web desiging company
web design & development banner
web design & development company
web design & development services
web design agency delhi
web design agency in delhi
web design and development services
web design companies in delhi
web design company delhi
web design company in delhi
web design company in gurgaon
web design company in noida
web design company list
web design company services
web design company website
web design delhi
web design development company
web design development services
web design in delhi
web design service
web design services company
web design services in delhi
web designer company
web designer delhi
web designer in delhi
web designers delhi
web designers in delhi
web designing & development
web designing advertisement
web designing and development
web designing and development company
web designing and development services
web designing companies in delhi
web designing company delhi
web designing company in delhi
web designing company in gurgaon
web designing company in new delhi
web designing company in noida
web designing company logo
web designing company sites
web designing company websites
web designing delhi
web designing in delhi
web designing in gurgaon
web designing in gurgaon
web designing service
web designing services
web designing services delhi

bhanu sreee said...

Thanks for sharing such good and informative content with all of us
Workday Training
Workday Online Training

Unknown said...

Appreciate you sharing, great article.Much thanks again. Really Cool.
net coure
net training

Government Jobs in Maharashtra said...

I'm really impressed about the info you provide in your articles. I must say am highly overwhelmed by your whole story. It’s not easy to get such quality information online nowadays. I look forward to staying here for a long time.

ba 3rd year result 2022 subject wise

Joy the Baker. said...

Unleash your channel's potential swiftly with our 'Buy YouTube Subscribers Instant' service; it's the turbocharge you need for rapid prominence in India's digital ecosystem. Secure a fast influx of real subscribers, augmenting your channel's reputation and discoverability in record time. Capitalize on the velocity of growth to outpace competitors, as our foolproof method complies with YouTube's standards, ensuring both quick results and lasting legitimacy. With an easy and transparent process, expect a seamless enhancement of your channel's appeal and a surge in organic traffic. Propel your YouTube journey with confidence and witness your subscriber count soar as our proven strategies take effect immediately.
https://www.buyyoutubesubscribers.in/

Food Blogs said...

Delhi's LASIK surgeons are a rare blend of skillful artisan and technological maestro, diligently sculpting clearer visions with each precise pulse of the laser. These ophthalmologists are the vanguards of innovation, continuously updated with the latest advancements in vision correction procedures. They are known for their thorough patient education and customization of surgeries, ensuring outcomes cater to individual patient's visual needs. In the heart of India, these surgeons operate with a level of dexterity and expertise that inspires confidence and attracts a growing international clientele. The LASIK surgeons of Delhi not only enhance sight but are deeply committed to the overall well-being and satisfaction of each person they treat, embodying professionalism and compassion in equal measure. Their dedication is reflected in the meticulous planning and post-operative care they provide, setting a global benchmark for ocular healthcare.
https://www.visualaidscentre.com/lasik-eye-surgery/

Homeopathic Doctors in Delhi said...

Purchasing real YouTube subscribers refers to legitimately acquiring viewers who are active, interested, and invested in your content. Unlike their artificial counterparts, these subscribers interact with your videos through likes, comments, and shares, bolstering your channel's engagement metrics. This organic growth not just aligns with YouTube's policies but also fortifies the robustness of your channel's community. Real subscribers can contribute to a channel's credibility and long-term success by creating a foundation for sustainable growth. Vendors that offer such services typically use more transparent methods, such as targeted promotions and social media advertisements to attract genuine followers. Despite potentially being more expensive and slower than purchasing cheap, inactive subscribers, the investment in real subscribers is fundamental for those committed to creating a genuine online presence.
https://sites.google.com/view/buyytsubscribers/

Smitten Kitchen said...

Buy YouTube Views Cheap is a service targeting creators seeking an affordable shortcut to increase their video traction. These views come with a low price tag, aimed to quickly elevate a video's statistics, thus enticing more organic viewers. The service promises rapid delivery and a notable boost in numbers, potentially jumpstarting a video's visibility. However, the authenticity and origin of these views are often questionable, potentially violating YouTube's terms of service. Users must be cautious as such practices can risk the channel's reputation and longevity. Cheap views rarely result in genuine engagement, and creators are advised to balance the risk against the fleeting benefits.
https://www.buyyoutubeviewsindia.in/

Adventurous Kate said...

Cheap website hosting in India appeals to budget-conscious individuals and small businesses by offering a cost-efficient web presence solution. These hosting plans provide the essentials—adequate storage and bandwidth—while ensuring uptime, key for maintaining constant online accessibility. They simplify the web experience with user-friendly interfaces and streamlined CMS installations, ideally catering to tech newcomers. However, performance can fluctuate with high traffic, and unbudgeted costs for advanced features or support may apply. These value-oriented hosting services are crucial in democratizing the web, allowing for a wide range of online initiatives to emerge and thrive within a modest budget.
https://onohosting.com/

Foodie Fantasies said...

Buying real YouTube subscribers is an essential strategy for creators seeking to cultivate a vibrant and engaged community around their channel. By prioritizing genuine, interested users over artificial inflation, creators can enjoy a boost in not only their subscriber count but, more importantly, in active engagement and interaction. This method promises an increase in likes, comments, and shares, reflecting a genuinely interested audience that supports the channel's content. Opting for real subscribers lays a solid foundation for sustainable growth, fostering a loyal audience that is more likely to stay engaged over time. Although acquiring real subscribers comes at a premium compared to other methods, the investment is justified by the long-term benefits of having an authentic and active viewer base. This not only improves the channel's metrics in a meaningful way but also enhances its appeal to advertisers and collaborators who value genuine engagement. Ultimately, purchasing real subscribers is a commitment to quality and authenticity in building a successful YouTube presence.
https://buyyoutubesubscribersindia.weebly.com/

Food52 said...

In the digital age, the reputation of a business on platforms such as Google can be pivotal to its success or failure. The practice of buying positive Google reviews represents a deceptive tactic, where businesses pay for counterfeit feedback to artificially inflate their online standing. This approach, aimed at enhancing a company's image and appeal through manipulated high ratings, directly breaches Google's stringent anti-fraud policies. The consequences of engaging in such malpractices are not trivial; they can lead to the removal of fabricated reviews and potential suspension of the business's listing on Google. Furthermore, this strategy fundamentally undermines the essence of authentic customer feedback, risking long-term damage to consumer trust and brand integrity. Despite the allure of a quick fix to reputation, the reliance on genuine, earned reviews remains crucial for sustainable business growth and credibility in the online marketplace.
https://www.seoexpertindelhi.in/buy-google-reviews/

Dr. Saurav Dixit said...

Looking to grow your Spotify following? Consider purchasing Spotify followers to expand your audience and boost your music's visibility! With more followers, you'll increase your credibility and attract even more organic listeners. Don't let your talent go unnoticed – invest in your success today. Choose from a variety of affordable packages tailored to your needs, making achieving your music goals easier than ever. Stand out from the crowd and leave a lasting impression on your audience. Take the first step towards musical success and buy Spotify followers now! Elevate your music career with this straightforward yet powerful strategy. Join countless satisfied artists who have experienced significant results. Don't miss out on this opportunity – start now and watch your Spotify presence grow!
https://www.spotifyfame.com/

Great Things said...

Looking to accelerate your Twitch channel's growth? Opt for a quick solution and buy Twitch followers fast! Increase your follower count rapidly to boost credibility and attract more viewers. With fast followers, you'll make a noticeable impact on your channel's popularity in no time. Skip the slow grind and jumpstart your Twitch journey with a surge of followers. Expand your reach and establish authority in your niche with a swift influx of followers. Don't wait months to see results – invest in fast Twitch followers for immediate impact. Take control of your channel's growth and propel yourself towards success with speed. Don't miss this opportunity to elevate your Twitch presence – buy followers fast today!
https://twitchviral.com/

The Points Guy said...

Seize this extraordinary opportunity designed for Indian nurses to elevate your career in the bustling heart of Singapore. Our nursing positions offer a harmonious balance of professional enrichment and personal contentment in a setting that’s both innovative and nurturing. Enjoy a highly competitive salary and unmatched work-life balance that ensures your well-being is a priority. Engage with a diverse team of healthcare professionals in an environment that treasures your unique background and expertise. Take advantage of our robust continuous learning initiatives that promise to keep you at the forefront of nursing excellence. Immerse in Singapore's lively cultural mosaic, from tantalizing cuisines to vibrant festivities. Here, your career is not just about providing care—it's about becoming part of a community that’s changing the face of healthcare globally. Join us, and make your mark in a city that values diversity and innovation.
https://dynamichealthstaff.com/nursing-jobs-in-singapore-for-indian-nurses

Expedition Diaries said...

Despite the competitive advantages offered by Google review services in India, critics argue that the authenticity of online reviews may occasionally be questioned. However, reputable service providers place a strong emphasis on offering genuine, user-generated content that complies with Google's strict guidelines. These services not only enhance a brand's online visibility but also significantly contribute to the decision-making process of potential customers. Through meticulously verified feedback, businesses can gain actionable insights, foster customer loyalty, and precisely tailor their services to meet market demands. The operational framework of these services ensures the maintenance of privacy and security standards, providing businesses and their customers with a secure platform for transparent communication. In essence, Google review services in India are redefining the digital landscape, making them an indispensable tool for businesses aiming to solidify their online presence and customer trust.
https://www.sandeepmehta.co.in/buy-google-reviews/

Homeopathic Doctors in Delhi said...

Want to accelerate your YouTube growth? Consider the option to buy fast YouTube views for instant visibility. Speed up your channel's progress and get noticed in no time. With fast views, you can jumpstart your reach and attract attention from potential viewers and collaborators. Skip the waiting game and get your content seen right away. Fast views offer a quick boost to your video's ranking and exposure. Amplify your online presence and stay ahead of the competition with rapid engagement. Don't miss out on valuable opportunities—opt for fast views to seize the spotlight. Experience the power of swift results in propelling your channel to success. Invest in fast views today and witness immediate impact on your YouTube journey.
https://sites.google.com/site/buyytviewindia/