> You are thinking of NORECOVERY, aren't you? TRUNCATE_ONLY is not a very
> good choice, as pointed out sybaseguru.
Yes, I meant NO_TRUNCATE as in the original example I posted and
NORECOVERY
during the full backup restore.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Erland Sommarskog" <esquel@[EMAIL PROTECTED]
> wrote in message
news:Xns9ACA17CF59B5Yazorman@[EMAIL PROTECTED]
> 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]
>
> Books 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
|
