Re: Applying tranaction log to old data file

(koszuf@[EMAIL PROTECTED]
) writes:
> on my SQL Server data file is corrupted. Unfortunately last backup was
> made about half year ago. Transaction log seems to be ok.
> Is it possible to restore data file from old backup and apply
> transactions from current transaction log?
 
Yes, if you have run with full or bulk-logged recovery for all these six
months. If you have run with simple recovery for just a second since your 
last backup, you can forget about it. 

In order to do this, you need to use the WITH NO_TRUNCATE option when you
backup your transaction log.

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