|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > recovery
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Anna Lin 2002-11-20, 8:23 pm |
| Hi all,
Our SQL 7 database failed. The only thing we have is a
full backup from August and the LOG file (the LDF) file.
Is there a chance for us to recover the database? How can
we do it?
Thanks, Anna
| |
| Uri Dimant 2002-11-21, 1:23 am |
| Anna
Did you perform log file backup during these months ( imean sep,oct,nov) ?
If you didn;t unfortantly you lost the data but you can restote full
backup from August .
Anna Lin <lliming12@yahoo.com> wrote in message
news:d08401c29101$770caf30$89f
82ecf@TK2MSFTNGXA01...
> Hi all,
>
> Our SQL 7 database failed. The only thing we have is a
> full backup from August and the LOG file (the LDF) file.
> Is there a chance for us to recover the database? How can
> we do it?
>
> Thanks, Anna
| |
| Tibor Karaszi 2002-11-21, 2:23 am |
| In addition to Uri's post:
You might want to check out www.lumigent.com. Whether the modification are still around in the
log file depends on database settings etc.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Anna Lin" <lliming12@yahoo.com> wrote in message
news:d08401c29101$770caf30$89f
82ecf@TK2MSFTNGXA01...
> Hi all,
>
> Our SQL 7 database failed. The only thing we have is a
> full backup from August and the LOG file (the LDF) file.
> Is there a chance for us to recover the database? How can
> we do it?
>
> Thanks, Anna
|
|
|
|
|