Blog Archives

Backup all databases using Backup-SqlDatabase cmdlet

Launch SSMS Right click on databases node, Select Menu item “Start PowerShell” Type in following command to backup all databases to Default backup folder dir |  Backup-SqlDatabase     Databases are backed up to Default backup folder   Advertisements

Posted in Backup, Scripting, SQL Power shell, SQL Server