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 |
|
CanadaDBA
583 Posts |
 Posted - 2004-08-24 : 13:22:17
|
| I have two backup files: One belongs to Aug 4th and another belongs to Aug 6th. Test_DB_200408042030.BAKTest_DB_200408062030.BAKIs it possible to create TLogs for Aug 5th? In other words, is it possible to build up the Test_DB_200408052030.BAK?Thanks,Canada DBA |
|
|
MuadDBA
628 Posts |
Posted - 2004-08-24 : 13:23:06
|
| No. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-24 : 13:53:25
|
| Well...have you been dumping the tranny logs?What's your back up methodology?Do you have scheduled jobs?What the recovery model?And what's your actual goal here?Brett8-) |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-08-25 : 14:01:26
|
I have schaduled jobs and my recovery model is Full. Well, I am not in trouble now but I have lost the Aug 5th backup and although it is not important any more but this question came up in my mind that is it possible to build it again?quote:
Originally posted by X002548
Well...have you been dumping the tranny logs?What's your back up methodology?Do you have scheduled jobs?What the recovery model?And what's your actual goal here?Brett8-)
Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-25 : 14:04:54
|
| It is not possible. Do your scheduled jobs include tlog backups?Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-25 : 14:09:36
|
| Not to beat a dead horse...But you could restore August 4th to another location, restore the tranny logs up to the point of when the 5th dump would have occurred..Then dump that database and call it the 5th...When do the daily dumps occur and how often do you dump the tranny logs?Brett8-) |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-08-25 : 14:15:57
|
I don't have tranny logs belong to the 5th. So, it seems it is not possible to recreate tranny logs having this situation.Thanks,quote:
Originally posted by X002548
Not to beat a dead horse...But you could restore August 4th to another location, restore the tranny logs up to the point of when the 5th dump would have occurred..Then dump that database and call it the 5th...When do the daily dumps occur and how often do you dump the tranny logs?Brett8-)
Canada DBA |
|
|
|
|
|
|
Create TLog having two BAK files