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
6+ years of experience in building Data Protection, Copy Data Management and Storage management applications, automation software and plugins for private datacenter 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.