Home > IT Answers > Storage > Recovering data from crashed database
Venkatdbait
35 pts.
 Recovering data from crashed database
Backup, Backup & recovery, Database Recovery, DBA, SQL Server, SQL Server backup
i   i have a question. my database  is crash .i don't have present backups.but i'm having  last week backups.  and  backup  strategy
sunday   10 p.m  full backup
everyday  1 p.m    differential backup
every one hour transaction log backup 
please give me reply as soon as
thanks & regards
venkat


Software/Hardware used:
SQL SERVER
ASKED: August 18, 2010  7:31 AM
UPDATED: August 20, 2010  1:09 PM
RELATED QUESTIONS
Answer Wiki:
Restore the full backup, then restore the most recent differential backup. Then restore the logs taken from after the differential backup until current. So basically sunday's full, then Yesterday's differential, then the log backups taken aften 1pm yesterday.
Last Wiki Answer Submitted:  August 18, 2010  6:27 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

i’m taking full backup sunday
sunday 10 p.m full backup
everyday 1 p.m differential backup
every one hour transaction log backup
ON saturday i take backup transaction log backup at 4 PM And in 4:40 pm database crash.
how to restore database without data loss?

Venkatdbait
 35 pts.