July 2, 2010 at 1:58 am
a snerio is this suppose, i took a full backup than took 2 transactional log backup than again took 2nd full backup than again 3rd n 4th transactional log backup, now i wud restore 1st full backup than restore all 4 transactional bakups, without restoring 2nd full backup. IS it possible?? and if not thn why??
July 2, 2010 at 2:05 am
sachinsoni84 (7/2/2010)
IS it possible??
Yes. Full backups do not truncate the transaction log.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2010 at 2:12 am
thank you i have been askd thid in interview and i answered correct.
one more thng wanna knw, if a stored procedure has 50 Tsql statment and is it is suddenly showing slow performance how wud i trouble shoot n tune it??
July 2, 2010 at 2:15 am
sachinsoni84 (7/2/2010)
one more thng wanna knw, if a stored procedure has 50 Tsql statment and is it is suddenly showing slow performance how wud i trouble shoot n tune it??
Please post this in a new thread. It's totally unrelated to backups and restores.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply