Dan Guzman (guzmanda@[EMAIL PROTECTED]
) writes:
>> Thanks for your response, but how can I make log backup, if my
>> transactiong log is not mounted. Should I restore old backup, manually
>> copy current transaction log and then create log backup or there is
>> other procedure?
>
> You should be able to backup the transaction log using the TRUNCATE_ONLY
> option even if the data file(s) is unavailable.
You are thinking of NORECOVERY, aren't you? TRUNCATE_ONLY is not a very
good choice, as pointed out sybaseguru.
But it appears koszuf does not have his database attached, and in that
case, it's more difficult, since you cannot attach a broken MDF.
--
Erland Sommarskog, SQL Server MVP, esquel@[EMAIL PROTECTED]
Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
