Backup and Restore

Hi All,
I may have a basic question in backup and restore (sql server 2000).
Am taking full backup on a daily basis, differential backup every 4 hours and transaction log backup every 30 mins. Lets assume the series is like this (am placing backup on a different machine);
8:00 AM -- Full backup
12:00 PM -- Differential backup
12:30 PM -- Transaction log backup
And at 12:55 PM the system crashes, after which i will not have access to the online transaction logs.
My question is,
Is there a way to recover 25 mins of data (from 12:30 - 12:55 PM), for which I haven't taken any backup?
Thanks in advance
GreneIf you don't have access to the transaction log, you won't be able to
perform a BACKUP with NO_TRUNCATE to backup the currently active transaction
log. Restore to the point of failure is therefore not possible. You can only
recover to 12:30 with your last transaction log backup.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Grene" <anonymous@.discussions.microsoft.com> wrote in message
news:C217F59C-8A1D-4150-9608-27B84DCBAC66@.microsoft.com...
> Hi All,
> I may have a basic question in backup and restore (sql server 2000).
> Am taking full backup on a daily basis, differential backup every 4 hours
and transaction log backup every 30 mins. Lets assume the series is like
this (am placing backup on a different machine);
> 8:00 AM -- Full backup
> 12:00 PM -- Differential backup
> 12:30 PM -- Transaction log backup
> And at 12:55 PM the system crashes, after which i will not have access to
the online transaction logs.
> My question is,
> Is there a way to recover 25 mins of data (from 12:30 - 12:55 PM), for
which I haven't taken any backup?
> Thanks in advance
> Grene
>|||It might be worth mentioning that if the SQL Server install is toast, but the ldf file(s) are there,
then the files can be transferred to another machine where SQL Server is installed and the
NO_TRUNCATE backup ban be ran on this machine. There's a KB on this scenario, btw.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:uLgo2KZrDHA.2440@.TK2MSFTNGP10.phx.gbl...
> If you don't have access to the transaction log, you won't be able to
> perform a BACKUP with NO_TRUNCATE to backup the currently active transaction
> log. Restore to the point of failure is therefore not possible. You can only
> recover to 12:30 with your last transaction log backup.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Grene" <anonymous@.discussions.microsoft.com> wrote in message
> news:C217F59C-8A1D-4150-9608-27B84DCBAC66@.microsoft.com...
> > Hi All,
> >
> > I may have a basic question in backup and restore (sql server 2000).
> >
> > Am taking full backup on a daily basis, differential backup every 4 hours
> and transaction log backup every 30 mins. Lets assume the series is like
> this (am placing backup on a different machine);
> > 8:00 AM -- Full backup
> > 12:00 PM -- Differential backup
> > 12:30 PM -- Transaction log backup
> > And at 12:55 PM the system crashes, after which i will not have access to
> the online transaction logs.
> >
> > My question is,
> > Is there a way to recover 25 mins of data (from 12:30 - 12:55 PM), for
> which I haven't taken any backup?
> >
> > Thanks in advance
> > Grene
> >
> >
>