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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-13 : 08:35:57
|
| Pugal writes "Hi,I am using SQL server 2000 in windows 2003 server( The service pack is 2) . I have the 1 week old backup and the most current .ldf - would that work out?. How would I have to go ahead?thanks Pugal" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-13 : 08:54:50
|
| I assume your one week old backup is a complete database backup and that your recovery is set to Full. Do you backup your transcation at any point?Sean Roussy |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-13 : 20:14:05
|
If you're using simple recovery mode, you are only going to be able to recover since the last full backup.If you are using one of the other recovery modes, you could "possibly" recover data with a tool like Lumigent Log Explorer (I think). People always think daily and hourly backups are important AFTER they lose everything.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Restoration