Archives: March 2016
When you look after more than a few SQL Servers you will need to perform the same actions against a number of them and that is where PowerShell will be of great benefit. Recently I needed to ensure that all SQL Servers had a certain Extended Event Session set to… Read more
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name case is important
BACKUP LOG [DatabaseName] TO URL = N'https://storageaccountname.blob.core.windows.net/containername/databasename_log_dmmyyhhss.trn' WITH CHECKSUM, NO_COMPRESSION, CREDENTIAL = N'credential'
will work but
BACKUP LOG [DatabaseName] TO URL = N'https://storageaccountname.blob.core.windows.net/CONTAINERNAME/databasename_log_dmmyyhhss.trn'</span> WITH CHECKSUM,…