recovery question

I have a full backup of a sql database on 4/27
I have a full backup of a sql datbase on 6/27
Is it possible to recover the data on 6/26 without seeing the changes on
6/27?On Tue, 24 Jul 2007 10:51:33 -0700, "nobody" <nobody@.nobody.com>
wrote:
>I have a full backup of a sql database on 4/27
>I have a full backup of a sql datbase on 6/27
>Is it possible to recover the data on 6/26 without seeing the changes on
>6/27?
If the database is in Full recovery mode, and you have all the log
backups from 4/27 through 6/26, then you can restore the 4/27 database
backup and apply all the log up to the point you want to stop
(point-in-time recover).
Otherwise, no.
Roy Harvey
Beacon Falls, CT|||In article <#JjvGthzHHA.5160@.TK2MSFTNGP05.phx.gbl>, nobody@.nobody.com
says...
> I have a full backup of a sql database on 4/27
> I have a full backup of a sql datbase on 6/27
> Is it possible to recover the data on 6/26 without seeing the changes on
> 6/27?
>
>
if you have full recovery turned on, and all the required LOG backups,
you can use "STOPAT" to do a point-in-time restore. If you have not run
a backup of the TLOG that should be the first thing you do.
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu|||I have no log backups. So No?
"Pete Berry" <PeteBerry@.Caltech.edu> wrote in message
news:MPG.210fe9254040420a98969a@.msnews.microsoft.com...
> In article <#JjvGthzHHA.5160@.TK2MSFTNGP05.phx.gbl>, nobody@.nobody.com
> says...
>> I have a full backup of a sql database on 4/27
>> I have a full backup of a sql datbase on 6/27
>> Is it possible to recover the data on 6/26 without seeing the changes on
>> 6/27?
>>
> if you have full recovery turned on, and all the required LOG backups,
> you can use "STOPAT" to do a point-in-time restore. If you have not run
> a backup of the TLOG that should be the first thing you do.
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu|||actually i found out its only a table within a database that needs to be
fixed or restored. how can this be done?
"nobody" <nobody@.nobody.com> wrote in message
news:u3qP2bjzHHA.5980@.TK2MSFTNGP04.phx.gbl...
>I have no log backups. So No?
> "Pete Berry" <PeteBerry@.Caltech.edu> wrote in message
> news:MPG.210fe9254040420a98969a@.msnews.microsoft.com...
>> In article <#JjvGthzHHA.5160@.TK2MSFTNGP05.phx.gbl>, nobody@.nobody.com
>> says...
>> I have a full backup of a sql database on 4/27
>> I have a full backup of a sql datbase on 6/27
>> Is it possible to recover the data on 6/26 without seeing the changes on
>> 6/27?
>>
>> if you have full recovery turned on, and all the required LOG backups,
>> you can use "STOPAT" to do a point-in-time restore. If you have not run
>> a backup of the TLOG that should be the first thing you do.
>> --
>> Graham (Pete) Berry
>> PeteBerry@.Caltech.edu
>|||In article <u3qP2bjzHHA.5980@.TK2MSFTNGP04.phx.gbl>, nobody@.nobody.com
says...
> I have no log backups. So No?
> "Pete Berry" <PeteBerry@.Caltech.edu> wrote in message
> news:MPG.210fe9254040420a98969a@.msnews.microsoft.com...
> > In article <#JjvGthzHHA.5160@.TK2MSFTNGP05.phx.gbl>, nobody@.nobody.com
> > says...
> >> I have a full backup of a sql database on 4/27
> >>
> >> I have a full backup of a sql datbase on 6/27
> >>
> >> Is it possible to recover the data on 6/26 without seeing the changes on
> >> 6/27?
> >>
> >>
> >>
> > if you have full recovery turned on, and all the required LOG backups,
> > you can use "STOPAT" to do a point-in-time restore. If you have not run
> > a backup of the TLOG that should be the first thing you do.
> > --
> > Graham (Pete) Berry
> > PeteBerry@.Caltech.edu
>
Again depends on the recovery model
simple => NO
full => yes if you do a backup of the tail of the log first
--
Graham (Pete) Berry
PeteBerry@.Caltech.edusql