Constraint Violating Yak Guru
Flowing Fount of Yak Knowledge
quote:Originally posted by raghuveer125I need to ask some question first.Is that full backup you took 2 days back?Is your database in full recovery mode?Have you taken any diff or transactional backup after taking last full backup?Is it possible to take log backup of your database now?In Love... With Me!
quote:Originally posted by raghuveer125You have only hope that you first try to take log backup if you can able to take log backupThen restore your latest full backup in norecovery and your log backup with recovery.if you can't able to take log bakup Then restore you latest full backup with recovery(Note:But if you restore this only full backup then you wont get any data stored after you full bakup)In Love... With Me!
quote:Originally posted by GilaMonsterTry a tail-log backup. A regular log backup will fail (the msd is missing)backup log .. no_truncateREstore the full with NORECOVERY, restore the log backup--Gail ShawSQL Server MVP