Del,
I know it's possible with SQL2000's backup feature,
but when I try in TDP GUI the checkbox is greyed out
with a ! in it, after I removed the data file.
Regards
Bo Nielsen
* 43 86 46 71
COOP Danmark a/s * (Internt postcenter): 6230
IT-Driftscenter * [EMAIL PROTECTED]
-----Oprindelig meddelelse-----
Fra: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sendt: 19. marts 2002 15:10
Til: [EMAIL PROTECTED]
Emne: Re: SQL log backup when Data-file is damaged??
> 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
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Smile a lot: it costs nothing and is beyond price.
