Home Forums SQL Server 2012 SQL 2012 - General I nEED backup query to backup to disk but RE: I nEED backup query to backup to disk but

  • July 27, 2016 at 6:24 pm

    #1892399

    liorvikel (7/27/2016)

    This is the error of agent in view history's

    ERROR: %1 is not a valid Win32 application.

    Now all we need is the code that caused that error and we might be able to help. The error is clearly saying that "%1" isn't a valid application and, since "%1" is typical of an operating system variable/parameter for a batch process, there's a piece of code somewhere that isn't being passed the correct parameter or the variable hasn't been defined correctly. Only you know or can find where this code is.

    As for backup scripts and *** previously mentioned on this thread, Ola Hallengren's code is good for those that prefer to use someone else's script. Google for it and download it and the instructions for installation and use.

    As a bit of a sidebar, if you don't already have it, download SQL Server "Books Online" and start reading about the different areas you want to know about, such a backups.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)