• first look at the job's code itself;

    is it using a cursor to get the list of databases, or is it a static list?

    for example, if i use red gate to generate a job for backing up my db's, it lists the of six specific databases, so new databases do not get added to the plan, i have to edit it and add them manually.

    is that the question?

    or is the question related to the COPYTO an alternate location when you said

    but it backs up only few dbs to the folder location for some reason.

    in that case, the backups might work, but if there is no space, the file might not get copied; depending on your code, any warnign or error might be suppressed.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!