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

Default image
Vignesh A Sathiyanantham
AWS Certified developer with 8 years of extensive experience working for Cloud and Datacenter solutions and leading a small team in a lean startup based on Bangalore, India

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.