Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-28 : 11:08:25
|
| I have a small doubt. full backup F1 6 amt-log backup T1 7 am.t-log backup T2 8 am.suppose if the system crashes at 8.30 amthe restore order is F1 T1 T2. through this we can restore up to 8 am . then what abt 30 min data.how can we eliminate that data loss.generally people say we have to use tail log backup.if we are not able to acess to sql server how can we take tail log backup. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 13:10:51
|
| You must be able to backup the transaction log in order to get any data after 8am.Are you going to give this site credit for all of the questions/answers you are getting?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-28 : 17:02:31
|
| Yah ... He is pretty soon publishing books for FAQ (SQL Server). |
|
|
|
r.amutha
Starting Member
6 Posts |
Posted - 2009-03-16 : 02:17:38
|
| Monday at 2 AM - Full backup and thenEveryday 9PM -Differential backup and thenevery ½ hour- Transactional log backupin that time, on Wednesday at 11.45 AM the Server Crash(sql server 2005 express edition).How will you restore the data files up to 11.45AM ?i can able to restore the data upto 11.30 AM but want to restore thedata from 11.30-11.45 AM.If database crash means v can use tail log backupbut if server crash means wat to doplz help me |
|
|
|
|
|
|
tail log backup