yup
SSCarpal Tunnel
Points: 4490
More actions
July 24, 2009 at 3:13 am
#134465
Even if master is in full recovery mode; why cant one take TLog backups for the same?
Grant Fritchey
SSC Guru
Points: 398886
July 24, 2009 at 6:11 am
#1029589
Because even if you change the recovery model for master, it's still going to behave as if it's in simple mode, by design.
Why are you trying to get log backups of master in the first place?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply