1000 times better than Microsoft documentation. I wasted a few hours before I searched on KZitem. Thanks for the video and the article.
@Kevin3NF
5 жыл бұрын
I'm glad you tried to sort it out yourself first...indicates a passion to learn!
@kishoreevani5813
2 жыл бұрын
Each step is explained very well sir. Please do more videos on Azure SQL. Thank you so much for your all videos. 👌👌
@timbuckingham8845
3 жыл бұрын
Excellent video as I was running into issues trying to get this setup with our SQL Server environment.
@Kevin3NF
3 жыл бұрын
Glad it was useful! Don't forget to do test restores as well!
@lord_rimuru_sama
4 жыл бұрын
Simple and informative. Thanks!
@uQuickStart
4 жыл бұрын
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
4 жыл бұрын
ouch...but glad I was able to help :)
@donbulaong
Жыл бұрын
Thank you so much! This is what I need!
@Kevin3NF
Жыл бұрын
So glad!
@muneerkhan100
3 жыл бұрын
I really like this video , Your explanation was too good in overall tutorial . Thank you Very much Kevin :)
@Kevin3NF
3 жыл бұрын
You're very welcome!
@ab5sr
6 жыл бұрын
Great! Loved the presentation.
@Kevin3NF
6 жыл бұрын
Thank you sir :)
@NetLib
5 жыл бұрын
Thanks for the very helpful tutorial.
@jmwinpath
5 жыл бұрын
Thanks for sharing it Kevin.
@hdgb123
6 жыл бұрын
Thanks Kevin! Nice work
@antoineguian1961
2 жыл бұрын
Hi Kevin, nice tuto, I just adjust the TSL version to 1.0 in the storage prperties
@abhishekv7171
3 жыл бұрын
Really helpful Kevin :)
@Kevin3NF
3 жыл бұрын
Glad you think so!
@vishnukondakindi5265
4 жыл бұрын
Great !! very thankful
@kirand3664
5 жыл бұрын
Great Kevin...Thanks for sharing vdo.
@rit1503
5 жыл бұрын
Thanks for sharing the details
@mart2041
6 жыл бұрын
Very helpful tutorial, thanks!
@MarkRead04
3 жыл бұрын
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
@AliRazaidi
4 жыл бұрын
Thanks wonder full.
@ameliaseni977
2 жыл бұрын
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
2 жыл бұрын
Glad you liked the video! I honestly have no idea how to throttle the speed...most people want it to go faster!
@bjarnekristensen1185
4 жыл бұрын
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
4 жыл бұрын
Check the bottom section of this blog post, or look for a command from www.dbatools.io dallasdbas.com/sql-backups-azure-storage/
@sigonz
4 жыл бұрын
Awesome
@anujgs1
3 жыл бұрын
For VMs I'd prefer to go with Azure Backups instead of blob storage
@Kevin3NF
3 жыл бұрын
For Azure VMs, sure but on prem physical or virtual, this gets them offsite
@singamsivagangireddy8175
4 жыл бұрын
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
4 жыл бұрын
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
@joeekpo5707
5 жыл бұрын
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
5 жыл бұрын
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. (kzitem.info/news/bejne/15WLxXucgIGmq20)
@lukepareigis1430
5 жыл бұрын
Agreed. Check Out Ola Hallengren He has great scripts for backing up DBs
@360ulearn8
3 жыл бұрын
Great tutorial. Thank you. Is it possible to automate the whole process?
@Kevin3NF
3 жыл бұрын
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.
@pamsoriano4291
4 жыл бұрын
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
4 жыл бұрын
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
4 жыл бұрын
@@Kevin3NF Thanks a lot! It worked!
@kulvirgakhal5470
4 жыл бұрын
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
4 жыл бұрын
This was a long time ago...what was the error message we got?
@kulvirgakhal5470
4 жыл бұрын
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
4 жыл бұрын
@@kulvirgakhal5470 Watching the video from after the "awkward pause" message, I see I had a mistake in the CREATE CREDENTIAL part
@hqcart1
2 жыл бұрын
How do i schedual it? and how do I delete old files on azure automatically?
@Kevin3NF
2 жыл бұрын
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/
@harvinderarora7921
5 жыл бұрын
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
5 жыл бұрын
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.
@Lazzari89
6 жыл бұрын
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
6 жыл бұрын
I'm not aware of any, but I haven't looked into it since I recorded this video. Thanks for watching!
@Lazzari89
6 жыл бұрын
@@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.
@ginhobrz92
6 жыл бұрын
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
6 жыл бұрын
What version of SQL Server are you using?
@Kevin3NF
6 жыл бұрын
What version of SQL Server? Backup to URL is not available to all versions
@ginhobrz92
6 жыл бұрын
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
6 жыл бұрын
URL is supported in SQL Server 2014...the most I can do for you in a KZitem comment is ask you to post the results of Select @@Version
@desidamayanti9133
5 жыл бұрын
7:07 :D
@prasannaanjaneyulu8475
3 жыл бұрын
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
3 жыл бұрын
What version, SP and CU of SQL Server
@prasannaanjaneyulu8475
3 жыл бұрын
@@Kevin3NF sql server 2014 sp2 enterprise evaluation edition
@Kevin3NF
3 жыл бұрын
docs.microsoft.com/en-us/troubleshoot/sql/admin/nonrecoverable-io-error-backup-url This is all the troubleshooting I can do in a KZitem comments section :)
@prasannaanjaneyulu8475
3 жыл бұрын
@@Kevin3NF I have used general storage kind only. but still, I am facing the same issue.
@surajthapa4555
4 жыл бұрын
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
4 жыл бұрын
I'm sorry, but I don't know what your question is...
@surajthapa4555
4 жыл бұрын
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
4 жыл бұрын
@@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
Пікірлер: 72