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 |
|
Frozen_123
Starting Member
33 Posts |
 Posted - 2007-11-06 : 18:44:59
|
| Hi all,Please find the following details and give me appropriate solution.Full backup: everyday :00:30 hrsDifferential backup: everyday 20:00 hrsTransction log backup: every 30 minsDatabase size is 150+ GBLastday one of our disk got crashed which had contains data and log file of the database at 22:25. Now my client wants all of the data till 22:25.I can recover data till 22:00 but how can I recover last 25 minutes data.Please help ASAP |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-06 : 19:26:06
|
| You can't, from the sounds of it. 5 minutes short of the needed backup. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-07 : 01:43:51
|
| You can try to make a TLog backup before you restore.If the LDF files are on different drives to the MDF, and it is the MDF which are corrupted, then this will usually work just fine. In which case after restore there will be no loss of data (other than any uncommitted partial transactions)If your MDF and LDF are NOT on different drives then they should be!If your LDF is damaged, but NOT the LDF, then it would be worthwhile [stop SQL Service first then] copying the MDF to make a fresh copy, perhaps on another server, and then attempting a single-file-attach. Once that is done then use DBCC CHECKDB to see if there is corruption. It might be that the MDF file was in steady-state at the time of the crash.I am interested that your Full backup is 00:30 and your Diff at 20:00. Why were these times chosen? Is the main part of the "working day" during 00:30 to 20:00, or 20:00 to 00:30?Kristen |
|
|
|
Frozen_123
Starting Member
33 Posts |
Posted - 2007-11-07 : 13:47:31
|
| Thanks Kristen,These schedules has chosen by me 'coz I have analized the average hit between 3:00 and 19:00 in the database is around 85% and between 19:30 to 2:30 the average hit is 3% As I've mentioned earlier that the datfile and logfile both were located on the same disk which has crashed.Austin |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-07 : 22:45:06
|
| Then recover db to 22pm is only thing you can do. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-08 : 00:16:35
|
| "the datfile and logfile both were located on the same disk which has crashed"I recommend that you change this for the future. |
|
|
|
|
|
|
Restoration Issue