• Benki Chendu (10/3/2013)


    The maintenance plan runs for all database backups. Its a generic job.

    Do you have any more inputs.

    Try to use double quotes around the file names:

    BACKUP DATABASE [safe_PreTMS ] TO DISK = N'"S:\Full\safe_PreTMS \safe_PreTMS _db_201310021607.BAK"' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

    Or like this:

    BACKUP DATABASE [safe_PreTMS ] TO DISK = N'S:\Full\"safe_PreTMS \safe_PreTMS _db_201310021607.BAK"' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

    _____________
    Code for TallyGenerator