Post reply

master db wont backup

  • May 10, 2005 at 10:47 am

    #109582

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

    please help

    thanks

    webdaddy

  • May 10, 2005 at 12:51 pm

    #557869

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

    backup database master to disk = ''

  • May 10, 2005 at 4:28 pm

    #557913

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

    webdaddy13

    Thanks everyone

     

  • May 11, 2005 at 12:41 am

    #557940

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

     

    Kindest Regards,

    Amit Lohia

  • May 11, 2005 at 8:41 am

    #558108

    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

  • July 7, 2006 at 8:23 pm

    #648097

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

    Pls share your experience with me.

     

    Thanks,

    -Sakthi

  • July 8, 2006 at 8:50 am

    #648108

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

  • July 12, 2006 at 9:48 am

    #648746

    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

  • July 12, 2006 at 5:39 pm

    #648850

    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

  • July 13, 2006 at 3:57 pm

    #649108

    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