Re: Applying tranaction log to old data file

On Jun 24, 11:06=A0pm, Erland Sommarskog <esq...@[EMAIL PROTECTED]
> wrote:
> =A0(kos...@[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.

To be honest - I'm not an SQL Server administrator - in my company I'm
responsible for Oracle databases. Person responsible for this server
asked me to restore database. I have  one transactional log (it has
size ab. 24 GB) and half year old data file (from backup).
What should I run to apply this log to the data file.

Thanks for your help.