Post reply

error in executing jobs

  • January 26, 2009 at 11:47 pm

    #130478

    hi all,

    i am getting this errors, when i run the jobs.can any one help me on this

    job of differentialbackup:

    WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'master_backup_20090127114039', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems wi... The package execution fa... The step failed.

    and another one

    job of full backup:

    Source: Back Up Database Task Executing query "BACKUP DATABASE [pubs] ... The package execution fa... The step failed.

  • January 27, 2009 at 2:14 am

    #933050

    i'd guess that the answer is in the error message....

    "You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database"

    remove the differential option for master. do a full backup.

  • January 27, 2009 at 6:04 am

    #933117

    Hi,

    master database need not be backed up every hour or every half-hour full/differential backup . One needs to backup the master database for the following reasons:

    1. after it is created

    2. if the configuration values are changed

    3. if the SQL logons are configured

    4. any changes are made to the database

    if you are looking for master database backup go for full backup

    Thank You

  • January 29, 2009 at 4:38 am

    #934515

    hi all

    i am again getting this error when i am doing the differential backup.

    error::

    TExec: The package execution returned DTSER_FAILURE (1).

    Started: 10:00:00 AM Finished: 10:00:07 AM Elapsed: 6.593 seconds.

    The package execution failed. The step failed.

    thanks in advance

    aswin...

  • January 29, 2009 at 5:14 am

    #934532

    As pointed out you cant create a Differential backup of the master database.

    "Keep Trying"

  • January 29, 2009 at 5:33 am

    #934545

    hi

    i didn't create differential backup on master database

  • January 29, 2009 at 5:39 am

    #934548

    if you are running the job to take Diferencial backup for other DB ,

    it look's like the package isn't executing using the right credentials.

    Check & Run As settings of the SQL Agent job that is created when

    you schedule the package and make sure that it is set correctly

    and check the connection

  • January 29, 2009 at 7:01 am

    #934631

    hi

    i recreated the job. every thing was fine here. the problem is not with the connection.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply