Re: SV: SQL log backup when Data-file is damaged??

2002-03-20 Thread Del Hoobler 

> 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.

Bo,

Well... in some unique situations like this it should
have been able to be performed by the command-line interface.
Did you try it?   TDPSQLC BACKUP databasename log /truncate
If that doesn't work, please call support so that
we can go through normal channels to handle this.

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.

SV: SQL log backup when Data-file is damaged??

2002-03-20 Thread Bo Nielsen 

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.