Recovery

Dear Guys...
Let's assume I have a Database Name "Production" and I have two Harddisk C
and D. In C drive I have production.mdf file and in D Drive I have
production.ldf. After a month C drive has been corrupted but D drive is
still live so now I am in a position to recover whole data or not through
production.LDF file?
Thanks
NOOR
Only if you have a backup of the database. Then you make a backup of the
current transaction log, and then restore the database and the transaction
log in order.
Jacco Schalkwijk
SQL Server MVP
"Noor" <noor@.ngsol.com> wrote in message
news:eirYAKpYEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Dear Guys...
> Let's assume I have a Database Name "Production" and I have two Harddisk C
> and D. In C drive I have production.mdf file and in D Drive I have
> production.ldf. After a month C drive has been corrupted but D drive is
> still live so now I am in a position to recover whole data or not through
> production.LDF file?
> Thanks
> NOOR
>
|||Hi,
With LDF file you can not recover the database. LDF file contains only
active transactions.
In the otherway if you have the MDF file you can try recovering the
database using sp_attach_single_file_db (see books online).
In your case only way to recover the database is using the last full
database backup. After that you can apply the transaction log backups,
provided if you have taken transaction log backup.
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:eirYAKpYEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Dear Guys...
> Let's assume I have a Database Name "Production" and I have two Harddisk C
> and D. In C drive I have production.mdf file and in D Drive I have
> production.ldf. After a month C drive has been corrupted but D drive is
> still live so now I am in a position to recover whole data or not through
> production.LDF file?
> Thanks
> NOOR
>