Please start any new threads on our new
site at http://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Our new SQL Server Forums are live!
Come on over! We've restricted the ability to create new threads on these forums.
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