Home Forums Programming Powershell Problem copying .bak with "$" in file path/name (PS running in SQL job step) RE: Problem copying .bak with "$" in file path/name (PS running in SQL job step)

  • April 24, 2013 at 6:10 pm

    #1609757

    Well... this fixed it. But now I'd like to know if anybody knows WHY it fixed it...

    #this fails

    $from = "\\srvrname\r$\SQL\MSSQL10_50.instname\MSSQL\Backup\srvrname$instname\DBNAME\FULL\srvrname$instname_DBNAME_FULL_" + $dd + "*.BAK"

    #but this works

    $from = "\\srvrname\r$\SQL\MSSQL10_50.instname\MSSQL\Backup\srvrname" + "$" + "instname\DBNAME\FULL\srvrname" + "$" + "instname_DBNAME_FULL_" + $dd + "*.BAK"

    Cursors are useful if you don't know SQL