PowerShell script to back up multiple databases RRS feed

  • Question

  • As you know, the script to back up a database in TSQL is

    BACKUP DATABASE adventureworks
    TO DISK = 'C:\Databases\Microsoft\adventureworks.bak'

    Let's suppose that I am backing up 100 databases?  Is there a PowerShell script that can perform this and drop the back up files in one location?

    Thursday, May 17, 2012 6:21 PM


All replies