master db wont backup

  • All other dbs execpt for the master backup SQL SVR 2000 when using maintenace plan saying backup all dbs.

    please help

    thanks

    webdaddy

  • Can you try to backup master from query analyzer and see if you get any errors.

    backup database master to disk = ''

  • will try but I am almost sure it should work...UIf it doesnt do you have a suspision????

    webdaddy13

    Thanks everyone

     

  • Does it return any error. Check the error log file also

     


    Kindest Regards,

    Amit Lohia

  • More than likely your maintenance plan is attempting to back up the transaction log for the Master database.  Only FULL backups can be taken of Master.  Try removing Master from your maintenance plan and see if that helps.

    I usually avoid maintnenance plans because of these sort of issues.  When I do use Maint plans, I will typically use one plan for user DBs and a separate plan for system DBs so that I can configure the steps differently.

    -km

  • Is it possible to take back up of master db or not?

    Pls share your experience with me.

     

    Thanks,

    -Sakthi

  • Yes.  You can backup the Master database, but only a full backup.  You cannot do a transaction log backup on Master.

  • hi,

    Depending on the recovery model set to each database,

    sql server allow full backups as well as log backups,

    but for master and tempdb only full backup can be taken on master database and you are not allowed to backup tempdb, but then if you could backup tempdb there is off no use. since every time you restart ur mssqlserver tempdb will be deleted and created newly.

    regards deena

    regards deena

  • This is an old post folks sorry but this has been long solved I havent gottena chance to get back to you ...but thanks.

     

    webdaddy13

  • Thanks for the response guys.

Viewing 10 posts - 1 through 9 (of 9 total)

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