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.c om...
> In article <#JjvGthzHHA.5160@.TK2MSFTNGP05.phx.gbl>, nobody@.nobody.com
> says...
> 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.c om...
>
|||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.c om...
>
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.edu