Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2008-03-05 : 23:16:52
|
| trn backup job failed for master ,msdb database giving an error Backup can not be performed on this database. This sub task is ignored |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 23:18:36
|
| They are in simple recovery model by default, so you can't do log backup for them. |
 |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-03-06 : 00:35:03
|
| I would remove the T-log backup from then rather then changing the recovery mode. I would not mess to much with the db options on systems databases.Chris Shawwww.SQLonCall.com |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2008-03-06 : 01:03:42
|
| isn't it necessary to take trn backup of master database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-06 : 01:28:41
|
quote:
Originally posted by arunsqladmin
isn't it necessary to take trn backup of master database.
No, plus it's not possible anyway.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
backup job failed