> How did I make a log backup of a SQL DB, when the data file is damaged???
> MS SQL Server2000
> TDP 2.2.1

Bo,

SQL 7 allows log backups as long as the primary data file
(the one with the system tables) is not damaged;
SQL 2000 allows log backups even if the primary data file
is damaged.

The ideal way to do a restore to the latest point-in-time is
first backup the log (usually with no truncate so there is
no attempt to change any data), then restore the full,
the diff, and all the logs necessary including the log
backed up just before the restore.

SQL 2000 was changed to always allow this ideal restore
unless the log itself is damaged. So, this is a feature,
an improvement, in SQL 2000.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

Leave everything a little better than you found it.
Smile a lot: it costs nothing and is beyond price.