I have a Powershell query to get the backup of my database. But i need to have the backup the data with different names like DATABASEBACKUP_CURRENTDATE. How can i achieve this?
./RedGate.SQLAzureBackupCommandLine.exe /as: AzureServerNAME/ad: AzureDatabaseName /au:AzureUserName /ap:AzurePassword /cc /s /ls:. /ld:LOCALDATABASENAME_CURRENTDATE /dl /v /ba
First, build a string that contains the current date:
Then call RedGate and use the date string as a parameter:
Ed: Copypaste/markup messed with brackets and colons, fixed 'em.