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