Currently Browsing: Powershell

Connect to SQL Server with PowerShell

Posted by Barac in Powershell, SQL Server on Nov 10th, 2017 | 0 comments

How to login using SQL Server Management Object (SMO) For windows authentication #################################################################### ####################### Windows Authentication ##################### #################################################################### [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-Null $s = new-object ('Microsoft.SqlServer.Management.Smo.Server') "InstanceName" $s.ConnectionContext.LoginSecure=$true $s.Databases | select name, size, status #################################################################### ...

Powershell / Backup SQL Server DBs to Azure Storage with Powershell script

Posted by Barac in Azure, Powershell, SQL Server on Oct 4th, 2017 | 2 comments

With this simple script, you can backup all databases to Azure daily, you can hardcode the parameters values or you can use task manager to pass them to the PS script. You need to have Azure PowerShell modules installed on your machine (how to). First off all, let’s try just to connect to your Azure Storage Account You can use azure credential-publishsettings file to do that, or putting the variables with access key, subscription and storage account name as in this example: #Variables param ( [string]$AzureKey= "AzureStorageAccessKey", [string]$AzureSubs= "YourSubscription", [string]$AzureStor=...

Next Entries »