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
Run the script with Server name and the backup directory as parameters
.\BackupAllDatabases.ps1 -serverName NW\CLUST -backupDirectory c:\backupdir
Passionate Developer with 7 years of extensive experience working for Data center related products. Contributed and lead the efforts in Solutioning and engineering in Nimesa Technologies for developing Dataprotection and Copy data management product for Private and Public Clouds
This is my personal weblog, opinions expressed here represent my own and not those of my employer.
All content provided on this blog is for informational purposes only and i will not be liable for any errors, losses, or damages from the display or use of this information.