Tag sqlserver

Backup & DR, Nimesa

Migrate SQL Server 2012 Database to SQL Server 2019

After the availability of SQL Server 2019 and Windows Server 2019, I decided to play around with that in my lab. Microsoft, owing to the new demands and other technological advancements in the software industry, has released the upgraded version…

Vignesh A Sathiyanantham
November 3, 2019

Nimesa

Change all MSSQL Database Recovery model to FULL using PowerShell

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.…

Vignesh A Sathiyanantham
May 9, 2019

Programming

Backup all your Microsoft SQL Server Databases

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…

Vignesh A Sathiyanantham
May 2, 2019

Physical Address

304 North Cardinal St.
Dorchester Center, MA 02124

Migrate SQL Server 2012 Database to SQL Server 2019

Change all MSSQL Database Recovery model to FULL using PowerShell

Backup all your Microsoft SQL Server Databases

Trending now