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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2003-11-17 : 23:03:49
|
| I have last months full backup.Currently i have only the log file (.LDF )Is there a way to restore the DB as as of today.Thanks in adnavce. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-18 : 12:06:29
|
If you are in full recovery, and there have been no log truncations since the last full backup (Unlikeley) you can do a log backup now, and do a point in time recovery to today, whatever time you want. But since you don't have the .MDF, i guess you can't do a log backup  .Looks like you are out of luck. -Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-18 : 12:26:33
|
| Yikes. Sounds like you are going to have to restore to last months full backup. This gives you reason to start backing up the database more regularly, also consider copying those files to tape.Tara |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-11-18 : 19:13:34
|
| As I know (but never use it so far) only LogExplorercan (but not must) help in this case. www.lumigent.com |
|
|
|
|
|
|
Restoring when only .LDF is present