Restoring to current info using LDF file?

Hi,
Just wondering if it is possible to get current info by
using the .LDF file? After the power outage last
Thursday, we lost a whole day of work (E: drive or .MDF
file was obliterated), but the F: drive or .LDF file is
available/okay/present. Can I use this file in anyway?
We only do backups at night not transactional or other
types of backups throughout the day (this will be changing
now...).
Thanks,
~DWithout the Main Database file then the log file is of no use to you. You
are going to have to RESTORE from backup I'm afraid
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"daj" <daj@.yeah.ca> wrote in message
news:074201c3657e$3442bee0$a501280a@.phx.gbl...
> Hi,
> Just wondering if it is possible to get current info by
> using the .LDF file? After the power outage last
> Thursday, we lost a whole day of work (E: drive or .MDF
> file was obliterated), but the F: drive or .LDF file is
> available/okay/present. Can I use this file in anyway?
> We only do backups at night not transactional or other
> types of backups throughout the day (this will be changing
> now...).
> Thanks,
> ~D|||IN addition to the other posters comments... you might try Log Explorer and
see if it will help you... ( that is part of what it might be able to do...)
www.lumigent.com
"daj" <daj@.yeah.ca> wrote in message
news:074201c3657e$3442bee0$a501280a@.phx.gbl...
> Hi,
> Just wondering if it is possible to get current info by
> using the .LDF file? After the power outage last
> Thursday, we lost a whole day of work (E: drive or .MDF
> file was obliterated), but the F: drive or .LDF file is
> available/okay/present. Can I use this file in anyway?
> We only do backups at night not transactional or other
> types of backups throughout the day (this will be changing
> now...).
> Thanks,
> ~D