Backup SQL Server to Azure Blob Storage

dallasdbas.com/sql-backups-az...
Basics of backing up SQL Databases to Azure...with all the bells and whistles stripped out. I walk you through everything required except getting yourself an Azure account, and purging old backup past retention period. The blog post to follow all of this is the link above

[@kishoreevani5813]

Each step is explained very well sir. Please do more videos on Azure SQL. Thank you so much for your all videos. 👌👌

[@sundeepyama]

1000 times better than Microsoft documentation. I wasted a few hours before I searched on KZbin. Thanks for the video and the article.

[@Kevin3NF]

I'm glad you tried to sort it out yourself first...indicates a passion to learn!

[@timbuckingham8845]

Excellent video as I was running into issues trying to get this setup with our SQL Server environment.

[@Kevin3NF]

Glad it was useful! Don't forget to do test restores as well!

[@lord_rimuru_sama]

Simple and informative. Thanks!

[@ab5sr]

Great! Loved the presentation.

[@Kevin3NF]

Thank you sir :)

[@NetLib]

Thanks for the very helpful tutorial.

[@hdgb123]

Thanks Kevin! Nice work

[@muneerkhan100]

I really like this video , Your explanation was too good in overall tutorial . Thank you Very much Kevin :)

[@Kevin3NF]

You're very welcome!

[@jmwinpath]

Thanks for sharing it Kevin.

[@donbulaong]

Thank you so much! This is what I need!

[@Kevin3NF]

So glad!

[@uQuickStart]

Hi Kevin, Great video..... Everything you need and nothing more..... I've used this twice now to setup Azure backups. Second time was due to Azure deleting everything when my free subscription expired

[@Kevin3NF]

ouch...but glad I was able to help :)

[@mart2041]

Very helpful tutorial, thanks!

[@kirand3664]

Great Kevin...Thanks for sharing vdo.

[@abhishekv7171]

Really helpful Kevin :)

[@Kevin3NF]

Glad you think so!

[@rit1503]

Thanks for sharing the details

[@antoineguian1961]

Hi Kevin, nice tuto, I just adjust the TSL version to 1.0 in the storage prperties

[@bjarnekristensen1185]

Hi Kevin - thanks for this walk through - good stuff. I want to ask you how to configure retention for your slq server database backups to azure container - maybe you have similar great video for this? Thanks, Bjarne

[@Kevin3NF]

Check the bottom section of this blog post, or look for a command from www.dbatools.io dallasdbas.com/sql-backups-azure-storage/

[@ameliaseni977]

Thanks, Kevin for the helpful info, Azcopy was excellent with us while migrating our file shares from windows to Azure blob or just backup SQL server to it but it is really so strong and fast and this causes a bandwidth-consuming, we found some tools that have the ability to migrate to Azure blob with the ability to control the transfer speed like Sharegate and Gs Richcopy 360 but both are paid, any idea, how can I solve this with AZcopy?

[@Kevin3NF]

Glad you liked the video! I honestly have no idea how to throttle the speed...most people want it to go faster!

[@singamsivagangireddy8175]

Hi Kevin, that's a great video and it really helped me. i would like to backup my database every month,how to automate this backup process in azure??

[@Kevin3NF]

I would use the scripts from Ola.Hallengren.com to automated backups, regardless of destination. YOU need a SQL edition with the SQL Agent to create and schedule jobs, or windows batch files. Each file should have a date/time stamp in the name

[@vktop2]

Nice video!, I have a question, if the blob storage where I want to export the database is in another subscription what do I need? thanks.

[@Kevin3NF]

No idea...permissions in Azure are something I am not familiar with

[@vishnukondakindi5265]

Great !! very thankful

[@joeekpo5707]

Thank you so much, I'm a junior DBA and trying to understand how to use SSIS as a tool to backup databases from on-prem to Azure. Do you have any Videos on that?

[@Kevin3NF]

Hi Joe! Using full blown SSIS for backups (to anywhere) is overkill. The built-in SQL Server maintenance plans use the SSIS framework to create packages and schedules for you. I prefer to use the free Ola Hallengren scripts myself in most cases for Backups, CheckDB, Index Maintenance, etc. (kzbin.info/www/bejne/rJC4kHqcfLSorpo)

[@lukepareigis1430]

Agreed. Check Out Ola Hallengren He has great scripts for backing up DBs

[@Lazzari89]

Hello Kevin, I have one question. Is there a way to save backups into folders that are inside the container? for example if in my SQL Server I have 10 DBs I want to save them all into separate folders using for example a maintenance task. Thank you for your help.

[@Kevin3NF]

I'm not aware of any, but I haven't looked into it since I recorded this video. Thanks for watching!

[@Lazzari89]

@@Kevin3NF Thank you for your answer, Kevin. I have one more question, do you know if it's possible to append backups in SQL Server to the Blob container? I'm trying to do it, but it always fails saying that "The file ABC/XYZ/X.BAK exists on the remote endpoint, and WITH FORMAT was not specified. Backup cannot proceed." I've tried using the INIT/NOINIT option to the backup but still fails. Thanks in advance.

[@360ulearn8]

Great tutorial. Thank you. Is it possible to automate the whole process?

[@Kevin3NF]

Pretty much everything can be automated...backups for sure, powershell scripts, etc. are all doable in SQL Agent. Ola Hallengren's scripts do Azure backups as well.

[@harvinderarora7921]

Hii kevin while restore the file are moved (mdf and ldf) is it store in local computer or cloud..plz let me know.Thanks.

[@Kevin3NF]

Restored databases leave the mdf/ldf files wherever you specify in the GUI or T-SQL. If you specify the D drive for mdf and G drive for LDF, they will be on D and G of the server you restore to.

[@AliRazaidi]

Thanks wonder full.

[@hqcart1]

How do i schedual it? and how do I delete old files on azure automatically?

[@Kevin3NF]

Schedule with the SQL Server Agent, just like any other backup. Cleanup using Powershell code at the bottom of this post: dallasdbas.com/sql-backups-azure-storage/

[@pamsoriano4291]

Hi Kevin, I'm getting this error from SQL Server when trying to do the backup: 'URL' is not a recognized Device Type option. I have the SQL Server 2012, I installed the most recently version of the SP1, but I'm still having the problem, could you give some advice?

[@Kevin3NF]

Did you also install CU2? I believe that is when it released. Ideally, you would be on the most recent SP (4): www.microsoft.com/en-us/download/details.aspx?id=56040 Test first before going to prod, as always

[@pamsoriano4291]

@@Kevin3NF Thanks a lot! It worked!

[@MarkRead04]

Thanks for sharing. Very well presented. I like well explained logical videos. Now I need to find how to take the .bak file and restore into Azure SQL Database and Azure SQL Managed Instance :) I'll search your video library Kevin to see if you have something to assist me. Cheers, Mark.

[@andriikomisarenko7785]

Azure SQL Database dosen't allow event create a credational

[@kulvirgakhal5470]

Hi Kevin, I keep getting the same error message you got when you tried to run the backup script the first time. What did you do to fix this issue?

[@Kevin3NF]

This was a long time ago...what was the error message we got?

[@kulvirgakhal5470]

Kevin Hill the error message can be seen at 20:09 onwards. The error message says “A non recoverable I/O error occurred on file...the backup database is terminating abnormally”

[@Kevin3NF]

@@kulvirgakhal5470 Watching the video from after the "awkward pause" message, I see I had a mistake in the CREATE CREDENTIAL part

[@sigonz]

Awesome

[@surajthapa4555]

If have any customer 1 sql server in on premise and multiple databases and database size is 500 GB . This inverment what is solution.

[@Kevin3NF]

I'm sorry, but I don't know what your question is...

[@surajthapa4555]

Sir , I have a SQL server in on premise and sql database size is 400GB . I want to my database backup take to Azure . What is solution .

[@Kevin3NF]

@@surajthapa4555 The entire video you are commenting on shows you how to do exactly that. Of course you need an Azure account, or your company does, but I cannot help you with that. The video is somewhat old but I think 400GB should be fine except for the amount of time it will take. Restoring from Azure will take at least the same amount of time. Maybe a better solution is to take a local backup and copy to Azure storage

[@ginhobrz92]

This msg is shown: Statement 'BACKUP DATABASE' is not supported in this version of SQL Server. How can I do it? I had to create a master key and a credential like this: CREATE DATABASE SCOPED CREDENTIAL mycredential WITH IDENTITY=...' because I cant create it like you did. Thanks in advance!!!

[@BoYcLuE]

What version of SQL Server are you using?

[@Kevin3NF]

What version of SQL Server? Backup to URL is not available to all versions

[@ginhobrz92]

Kevin Hill versión 12.0, the thing is I can import/export de database but only saves the datatables, not the procedures. Could you give me some advice?

[@Kevin3NF]

URL is supported in SQL Server 2014...the most I can do for you in a KZbin comment is ask you to post the results of Select @@Version

[@anujgs1]

For VMs I'd prefer to go with Azure Backups instead of blob storage

[@Kevin3NF]

For Azure VMs, sure but on prem physical or virtual, this gets them offsite

[@prasannaanjaneyulu8475]

I am receiving this error. AzureStorage account name is correct Msg 3271, Level 16, State 1, Line 7 A nonrecoverable I/O error occurred on file "sqlbackups94.blob.core.windows.net/sqlbackup/Test_02.bak:" Backup to URL received an exception from the remote endpoint. Exception Message: The remote server returned an error: (400) Bad Request.. Msg 3013, Level 16, State 1, Line 7 BACKUP DATABASE is terminating abnormally.

[@Kevin3NF]

What version, SP and CU of SQL Server

[@prasannaanjaneyulu8475]

@@Kevin3NF sql server 2014 sp2 enterprise evaluation edition

[@Kevin3NF]

docs.microsoft.com/en-us/troubleshoot/sql/admin/nonrecoverable-io-error-backup-url This is all the troubleshooting I can do in a KZbin comments section :)

[@prasannaanjaneyulu8475]

@@Kevin3NF I have used general storage kind only. but still, I am facing the same issue.

[@desidamayanti9133]

7:07 :D