back up & restore | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

back up & restore

hi,I have one doubt abt backup and recovery . I`ve to take full database backup on saturday and daily differential back up and for 2 hours once transaction log back up .if I have transaction log back up upto 12pm on tuesday and @ 1 pm server goes down . what r the steps to restore maximum data rajendra
From EM , try a restore. It will show you what are all the backups to be considered for a pointtime recovery . or 1)resore very recent full backup
2)restore very recent diff backup
3)resore all logs taken after the diff backup(the one you restored in abov step) .
check this for visual guidelines:
http://techrepublic.com.com/5100-1035_11-1041267.html#
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by RAJENDRA</i><br /><br />hi,I have one doubt abt backup and recovery .<br /><br />I`ve to take full database backup on saturday and daily differential back up and for 2 hours once transaction log back up .if I have transaction log back up upto 12pm on tuesday and @ 1 pm server goes down .<br /><br />what r the steps to restore maximum data<br /><br />rajendra<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />I think you would then restore the last full backup and then latest diffential backup…and <i>if your harddisk is not damaged then you could attached Database.mdf and logfile.ldf</i> .<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />hsGoswami<br />[email protected]
]]>