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…

January 8, 2019 Vignesh Sathiyanantham

Nimesa Software based Data protection and copy data management solution supports Microsoft SQL Server full backup and log backup, recently we got a customer request why Nimesa is skipping the Simple recovery model database during log backup Simple recovery model doesnt support log backups. Simple recovery model database automatically reclaims the log space to keep space requirements small, essentially eliminating the need to manage the transaction log space The following features are not supported by SQL Server if your database is in Simple recovery model Log shippingAlways On or Database mirroringMedia recovery without data lossPoint-in-time restores Under the simple recovery…