Recovery database

I have a database, but It's delete. I only file .LDF of database, Please, he
lp recovery database.
Thanks,Without the data file (mdf, ndf), you're pretty much stuck. It would help
if you've made backups. Alternatively, you could try using one of the many
disk recovery apps and hope for the best (OnTrack (commercial), Handy
Recovery (freeware)). Try not to store anything onto the disk that used to
contain the data files.
Peter Yeoh
http://www.yohz.com
Need smaller backup files? Try MiniSQLBackup
"HCNT" <anonymous@.discussions.microsoft.com> wrote in message
news:AF33FF5B-0AE0-4F04-BA3A-40E750222E29@.microsoft.com...
> I have a database, but It's delete. I only file .LDF of database, Please,
help recovery database.
> Thanks,|||Hi,
You cant recover a database with an LDF file. LDF file only contains the
active transactions information. All the data / objects will be kept in MDF
file.
Note:
A database can be recovered only if you have the MDF/NDF file for that
database. It is always recommended to take a backup of
database daily.
Thanks
Hari
MCDBA
"HCNT" <anonymous@.discussions.microsoft.com> wrote in message
news:AF33FF5B-0AE0-4F04-BA3A-40E750222E29@.microsoft.com...
> I have a database, but It's delete. I only file .LDF of database, Please,
help recovery database.
> Thanks,|||Without backup, there's nothing you can do but to rebuild your database
from scratch.
Eric
HCNT wrote:

> I have a database, but It's delete. I only file .LDF of database, Please,
help recovery database.
> Thanks,
Eric Li
SQL DBA
MCDBA