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.

25 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/

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/

Smitten Kitchen said...

Pancreatic cancer specialists in Ahmedabad are distinguished by their deep-rooted expertise and a compassionate approach towards treating this challenging disease. These healthcare professionals are not only adept at navigating the complexities of cancer treatment but also excel in providing a tailored experience that respects each patient's unique situation. Their practices are enhanced by the most advanced technology available, from precise diagnostic tools to innovative therapies that aim to control and cure. With a commitment to research and a dedication to the well-being of their patients, they focus on treatments that promise the best outcomes while maintaining the highest quality of life possible. Beyond medical interventions, these specialists are also committed to raising awareness about pancreatic cancer and fostering preventative measures within the community. Their holistic approach, combining medical excellence with human empathy, sets a new standard in cancer care in Ahmedabad.
https://drvirajlavingia.com/

manav saini said...

The Breast Cancer Oncologist in Gurgaon is renowned for their exceptional expertise and compassionate care in the field of oncology. Specializing in both the medical and holistic aspects of cancer treatment, this physician employs a comprehensive approach that integrates cutting-edge therapies with supportive patient care. Their profound dedication to advancing breast cancer treatment is evident in their use of personalized therapy plans, tailored to match the unique genetic makeup and needs of each patient. With a strong emphasis on research and innovation, the oncologist stays at the forefront of the latest medical breakthroughs, ensuring that patients receive the most advanced treatments available. The oncology clinic offers a warm and empathetic environment, emphasizing comfort and trust in the patient-doctor relationship. This commitment to patient-centric care, combined with their clinical acumen, makes the Breast Cancer Oncologist a distinguished figure in Gurgaon's medical community, transforming the lives of those they treat with expertise, kindness, and unparalleled diligence.
https://www.breastoncosurgery.com/

Dr. Saurav Dixit said...

Ready to grow your Spotify presence? Consider the option to buy Spotify followers and boost your music career. Increase your follower count authentically and attract more listeners to your tracks. Don't settle for slow growth – invest in Spotify followers for immediate impact. Elevate your profile's visibility and reach a wider audience with genuine followers. Join successful artists who have leveraged this strategy to build a strong fan base. Don't miss out on this opportunity to stand out in a crowded music landscape. Experience organic growth and gain credibility with each new follower. Invest in your music's success today and unlock new opportunities on Spotify!
https://www.spotifyfame.com/

Destination Diaries. said...

Dr. Shona Nag is a pioneering oncologist based in Pune, India, with over 20 years of experience in the field. She specializes in advanced cancer treatments, integrating the latest medical technologies and personalized care for optimal outcomes. Known for her empathetic approach, Dr. Nag develops tailored treatment plans for each patient. Her extensive contributions to oncology research are well-documented in renowned medical journals. As an influential speaker, she shares her expertise at international oncology conferences, shaping future cancer treatment methodologies. Dr. Nag is deeply committed to patient education and empowerment, which is central to her practice. Continually innovating, her strategies markedly improve patient outcomes and quality of life. She is universally acknowledged as a leading authority in oncology.
https://www.drshonanagbreastcancer.in/contact-best-medical-oncologist-near-me-cancer-center-in-pune/

bloggingbasics101 said...

Hair regrowth treatment for men in Australia is primarily aimed at addressing the concerns of androgenetic alopecia, commonly known as male pattern baldness. This topical solution, such as Minoxidil, works by invigorating hair follicles and enhancing blood circulation in the scalp, which promotes the regrowth of hair in thinning areas. Available in both 2% and 5% concentrations, these treatments cater to varying levels of hair loss severity and allow for personalized usage. Regular application, typically recommended twice daily, is essential for achieving optimal results, with many men noticing improvements within a few months. Although generally safe, some may experience mild side effects, including scalp irritation or unwanted facial hair growth. Integrating a healthy lifestyle and proper hair care practices can further enhance the effectiveness of these treatments. It is advisable for individuals to consult with a healthcare professional to determine the most appropriate treatment tailored to their needs. The growing demand for these treatments reflects a significant trend towards addressing hair loss and boosting confidence among men in Australia.
https://generichealth.com.au/minoxidil-hair-loss/

sdaff said...

Low cost website design in Delhi provides an essential service for startups and small businesses aiming to establish a robust online presence without breaking the bank. These design services are tailored to create visually appealing and functional websites that reflect the brand's identity. Providers often offer a range of packages, allowing clients to select the most suitable option based on their budget and specific needs. Key features typically include responsive layouts that work seamlessly across devices, user-friendly interfaces that enhance navigation, and basic SEO optimisation for improved search visibility. Additionally, many providers include ongoing support and maintenance to ensure the website remains updated and secure. This approach not only aids in promoting entrepreneurship but also empowers businesses to engage effectively with their target audience in the digital landscape. By leveraging affordable web design solutions, companies can bolster their competitive edge and expand their market reach. Ultimately, low cost website design in Delhi signifies a blend of quality, affordability, and accessibility for aspiring entrepreneurs.
https://olycoder.com/low-cost-website-design