• This script is genius - but I'm having some issues with it. I've manged to get it to run on my XP machine, running sql 2005 - but when I change out the DB names and the server, and run it on a server 2008 box, I run into issues.

    I've got server 2008, running SQL Express 2005 and another 2008 machine running SQL Express 2008. I ran into this same error on my XP machine, but it was a result of the path not existing. I have created the path on the two servers.

    The error message I'm getting is:

    Exception calling "SqlBackup" with "1" argument(s): "Back failed for server 'server\instance,port'. "

    At line:1 char:20

    + $dbbackup.sqlbackup <<<< ($server);

    +categoryInfo :Notspecified: (:) [], MethodinvocationException

    + FullyQualifiedERrorId : DotNetMethodException

    Any assistance would be much appreciated.

    As a side note, I've already tried this: http://sqlaj.wordpress.com/2010/10/10/error-running-sql-2008-smo-sqlbackup/