Backup Llast log - Primary crashed

HAs any one backed up the log when data files are damaged? I am
following KB article Q253817. It is not working. When I run the backup
command , it gives mdf not exists in sql server 2000. Any one has
success?If you show us the BACKUP LOG command and the exact error message (including
error number etc) we can
hopefully comment. Easiest s to execute these commands from Query Analyzer a
nd not try to drive the UI in EM.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64ff17@.posting.goog
le.com...
> HAs any one backed up the log when data files are damaged? I am
> following KB article Q253817. It is not working. When I run the backup
> command , it gives mdf not exists in sql server 2000. Any one has
> success?|||Thanks for your reply. The first scenario was master was intcact, lost
the datafile of DB. Then the backup log with no_truncate worked
fine.(though it giving errors with MSDE version).
The second scenario, master was intact. The datafile of DB lost. I've
created another db and dropped both daat and log of newly created db.
Copy the crashed DB log to new DB as per KB article except using the
same master. When sql server starts up, that is making the new DB
offline. When run the backup log with no_truncate, it gives error.
Could not open FCB for invalid file ID 0 in database 'test1'
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<#
#mDbq#FEHA.3540@.TK2MSFTNGP09.phx.gbl>...
> If you show us the BACKUP LOG command and the exact error message (includi
ng error number etc) we can
> hopefully comment. Easiest s to execute these commands from Query Analyzer
and not try to drive the UI in EM.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "tram" <tram_e@.hotmail.com> wrote in message news:26ee1067.0404010502.2f64
ff17@.posting.google.com...