Re: Applying tranaction log to old data file

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

-- 
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

<koszuf@[EMAIL PROTECTED]
> wrote in message 
news:7858f9ba-fd20-44d6-b149-82dd9427b0b0@[EMAIL PROTECTED]
> As Erland said, you need to first backup the transaction log with
> NO_TRUNCATE. For example:
>
> BACKUP LOG MyDatabase
> TO DISK = 'C:\MyDatabase_Log.bak'
> WITH NO_TRUNCATE;

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?