May 9, 2019 Vignesh Sathiyanantham

Changing the individual database recovery model is very simple with the Microsoft SSMS. But recently in one of our Nimesa customer environments, he had 200 databases in a non-production instance and all the databases are in the simple recovery model. That user wanted to do POC of Nimesa Application-aware backup and Point in time recovery for MS SQL database server, Log backups are not possible with the simple recovery model, so I executed a small PowerShell script which changes all the databases to the FULL recovery model from the simple recovery model Get-SqlDatabase -ServerInstance NW1\CLUST2 The above Powershell command gets…

May 2, 2019 Vignesh Sathiyanantham

Creating a full backup in the SQL server using SSMS is very simple, but if you have 10’s of databases you find bit difficult to backup all databases in one go. So i write a small Powershell script which gets the list of databases and takes the backup except the system databases https://gist.github.com/asvignesh/9c2f275c9418b038022ceffa94ba2152 Run the script with Server name and the backup directory as parameters .\BackupAllDatabases.ps1 -serverName NW\CLUST -backupDirectory c:\backupdir