May 10, 2005 at 10:47 am
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
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
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
Does it return any error. Check the error log file also
Amit Lohia
May 11, 2005 at 8:41 am
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
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
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
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
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
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