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 |
|
chetancool
Starting Member
34 Posts |
 Posted - 2005-01-17 : 02:18:06
|
| Hi group.This problem is faced by my friend and i was unable to solve that, so i m putting this in front of you.DBA has taken fullbackup at monday 1300 hrs. at that time in one table called customer_visits, there was 200 entries. Database has crashed om Tuesday 1000 hrs. At that time, according to sales team, there should be 15000 entries in the customer_visits table. So tell me how to recover the whole table with 15000 reocrds since all datta is critical for weeklky report and individual customer information.Thanks in advance.cjain |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-17 : 02:39:10
|
| do you have routine full and log backups?if yes, you can do a point in time restoration before the crash happened.if no and if the log file is still intact, you can use a log reader to restore whatever you can restore. for one, try apexsqllog--------------------keeping it simple... |
 |
|
|
chetancool
Starting Member
34 Posts |
Posted - 2005-01-17 : 04:17:31
|
| thanks jan.No this DBA does not have routine full and log backup.Can u tell me how u use log reader to restore the log file.cjain |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-17 : 05:30:10
|
quote:
Originally posted by chetancool
thanks jan.No this DBA does not have routine full and log backup.Can u tell me how u use log reader to restore the log file.cjain
goto www.apexsql.com and download their free version, you can even ask them if you encounter some problems and they'll surely help you out.  --------------------keeping it simple... |
|
|
|
|
|
|
Restoration problem