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
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?
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?
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. (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-v_U_GfGOux8.html)
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
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?
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
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.
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
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”
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.
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/
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 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.
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.
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!!!
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?
@@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
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.
docs.microsoft.com/en-us/troubleshoot/sql/admin/nonrecoverable-io-error-backup-url This is all the troubleshooting I can do in a RU-vid comments section :)