Point in time recovery with differential backup

Consider this scenerio in SQL 2000...
I have a full backup of a DB taken at 6AM on Sunday. After the full
backup - a T-Log backup is taken every hour. At 6PM a process is run where
a differential backup is taken and the T-Log backups between 6AM and 6PM are
deleted. Should I still be able to do a point in time recovery to a time
like 3PM?
When trying to invoke a point in time recovery from SQL EM - I get a message
indicating that the earliest time allowed for me to specify is 6PM (the time
of the differential backup).
I am thinking that perhaps SQL Server does not have the ability to recover
to a point in time in the differential backup... like it's all or nothing.
Is this true or am I most likely doing something wrong?
Thanks in advance.
Hi,
No, you cant do a point in recovery if your trasnaction log backup files are
deleted.
Otherwise you should have done the belwo steps:-
1. Restore the full backup with NORECOVERY to a new database
2. Restore the subsequent transaction log backups till 02 PM with NORECOVERY
3. Restore the 3PM traansaction log backup with STOPAT option and WITH
RECOVERY.
THis will do a POINT-IN-TIME recovery in the new database.
Thanks
Hari
MCDBA
"TJTODD" <tjtodd@.anonymous.com> wrote in message
news:es9xcqAWEHA.3336@.TK2MSFTNGP11.phx.gbl...
> Consider this scenerio in SQL 2000...
> I have a full backup of a DB taken at 6AM on Sunday. After the full
> backup - a T-Log backup is taken every hour. At 6PM a process is run
where
> a differential backup is taken and the T-Log backups between 6AM and 6PM
are
> deleted. Should I still be able to do a point in time recovery to a time
> like 3PM?
> When trying to invoke a point in time recovery from SQL EM - I get a
message
> indicating that the earliest time allowed for me to specify is 6PM (the
time
> of the differential backup).
> I am thinking that perhaps SQL Server does not have the ability to recover
> to a point in time in the differential backup... like it's all or nothing.
> Is this true or am I most likely doing something wrong?
> Thanks in advance.
>

Point in time recovery with differential backup

Consider this scenerio in SQL 2000...
I have a full backup of a DB taken at 6AM on Sunday. After the full
backup - a T-Log backup is taken every hour. At 6PM a process is run where
a differential backup is taken and the T-Log backups between 6AM and 6PM are
deleted. Should I still be able to do a point in time recovery to a time
like 3PM?
When trying to invoke a point in time recovery from SQL EM - I get a message
indicating that the earliest time allowed for me to specify is 6PM (the time
of the differential backup).
I am thinking that perhaps SQL Server does not have the ability to recover
to a point in time in the differential backup... like it's all or nothing.
Is this true or am I most likely doing something wrong?
Thanks in advance.Hi,
No, you cant do a point in recovery if your trasnaction log backup files are
deleted.
Otherwise you should have done the belwo steps:-
1. Restore the full backup with NORECOVERY to a new database
2. Restore the subsequent transaction log backups till 02 PM with NORECOVERY
3. Restore the 3PM traansaction log backup with STOPAT option and WITH
RECOVERY.
THis will do a POINT-IN-TIME recovery in the new database.
--
Thanks
Hari
MCDBA
"TJTODD" <tjtodd@.anonymous.com> wrote in message
news:es9xcqAWEHA.3336@.TK2MSFTNGP11.phx.gbl...
> Consider this scenerio in SQL 2000...
> I have a full backup of a DB taken at 6AM on Sunday. After the full
> backup - a T-Log backup is taken every hour. At 6PM a process is run
where
> a differential backup is taken and the T-Log backups between 6AM and 6PM
are
> deleted. Should I still be able to do a point in time recovery to a time
> like 3PM?
> When trying to invoke a point in time recovery from SQL EM - I get a
message
> indicating that the earliest time allowed for me to specify is 6PM (the
time
> of the differential backup).
> I am thinking that perhaps SQL Server does not have the ability to recover
> to a point in time in the differential backup... like it's all or nothing.
> Is this true or am I most likely doing something wrong?
> Thanks in advance.
>

Point in time recovery with differential backup

Consider this scenerio in SQL 2000...
I have a full backup of a DB taken at 6AM on Sunday. After the full
backup - a T-Log backup is taken every hour. At 6PM a process is run where
a differential backup is taken and the T-Log backups between 6AM and 6PM are
deleted. Should I still be able to do a point in time recovery to a time
like 3PM?
When trying to invoke a point in time recovery from SQL EM - I get a message
indicating that the earliest time allowed for me to specify is 6PM (the time
of the differential backup).
I am thinking that perhaps SQL Server does not have the ability to recover
to a point in time in the differential backup... like it's all or nothing.
Is this true or am I most likely doing something wrong?
Thanks in advance.Hi,
No, you cant do a point in recovery if your trasnaction log backup files are
deleted.
Otherwise you should have done the belwo steps:-
1. Restore the full backup with NORECOVERY to a new database
2. Restore the subsequent transaction log backups till 02 PM with NORECOVERY
3. Restore the 3PM traansaction log backup with STOPAT option and WITH
RECOVERY.
THis will do a POINT-IN-TIME recovery in the new database.
--
Thanks
Hari
MCDBA
"TJTODD" <tjtodd@.anonymous.com> wrote in message
news:es9xcqAWEHA.3336@.TK2MSFTNGP11.phx.gbl...
> Consider this scenerio in SQL 2000...
> I have a full backup of a DB taken at 6AM on Sunday. After the full
> backup - a T-Log backup is taken every hour. At 6PM a process is run
where
> a differential backup is taken and the T-Log backups between 6AM and 6PM
are
> deleted. Should I still be able to do a point in time recovery to a time
> like 3PM?
> When trying to invoke a point in time recovery from SQL EM - I get a
message
> indicating that the earliest time allowed for me to specify is 6PM (the
time
> of the differential backup).
> I am thinking that perhaps SQL Server does not have the ability to recover
> to a point in time in the differential backup... like it's all or nothing.
> Is this true or am I most likely doing something wrong?
> Thanks in advance.
>sql