Yesterday while working for a customer, I had to setup Log Shipping for SQL Server 2016 on Azure. Setting up Log Shipping is easy and well documented here at Below Link:
But log shipping requires a File Share to be created so that both servers Primary and Secondary can access the Transaction Logs.
To setup file sharing, I used Azure Storage File Service. But this required some specific configuration.
I had to Add the File Share Credentials to Windows Credentials Manager of both the systems for SQL Server & SQL Server agent service accounts using following steps:
- Open CMD.exe for a specific user using following in windows run box
runas /user:<accountname for sql agent> cmd.exe
- Add Credentials to Windows Credentials Manager using:
C:\>cmdkey /add:<yourstorageaccountname>.file.core.windows.net /user:<domainname>\<yourstorageaccountname> /pass:<YourStorageAccountKeyWhichEndsIn==>
After doing this the file share was available to service accounts as the credentials were being saved in windows credentials manager.
All I had to was to following along the article mentioned earlier and I had Setup Log Shipping on Azure using Azure File Shares.