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 |
|
hitesh6221
Starting Member
28 Posts |
 Posted - 2008-09-27 : 04:13:00
|
| Hi Frnd,I have one problem, Please help meI have full backup of DB at Sunday 8:00 morningI have Deff backup of DB at every day 8:00 morningand I am taking Tlog every one hour,Now my DB is gone cress at 12:40 AMI am able to restore DB upto 12:00 AM but how to restore 00:40 minute's Data can any one help me ASAPThanks in advanceRegards,Hiotesh SoniRegards,Hitesh Soni |
|
|
shafi.spl
Starting Member
10 Posts |
Posted - 2008-09-27 : 04:29:29
|
| take tail log backup of 12;40pm with no_truncate did u don it? |
 |
|
|
hitesh6221
Starting Member
28 Posts |
Posted - 2008-09-27 : 06:55:15
|
| Can you please give syntex of taking tail logRegards,Hitesh Soni |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-27 : 12:08:00
|
quote:
Originally posted by hitesh6221
Hi Frnd,I have one problem, Please help meI have full backup of DB at Sunday 8:00 morningI have Deff backup of DB at every day 8:00 morningand I am taking Tlog every one hour,Now my DB is gone cress at 12:40 AMI am able to restore DB upto 12:00 AM but how to restore 00:40 minute's Data can any one help me ASAPThanks in advanceRegards,Hiotesh SoniRegards,Hitesh Soni
Did you mean Database got corrupted? Take tail backup with no_truncate as shafi said.Then restore full backup ,diff back and all tran log backup with tail backup with NORECOVERY MODE.Lastly,Restore database with RECOVERY MODE. You should be in full Recovery model for this. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-27 : 12:09:00
|
quote:
Originally posted by hitesh6221
Can you please give syntex of taking tail logRegards,Hitesh Soni
Look at syntax in BooksOnline. |
|
|
|
|
|
|
|
|
Back up restoration