Backup / restore question

I had a SQL server with some harddrive problems. So, a full backup was made
(manually using Enterprise Manager) and restored in a new machine
successfully using Enterprise Manager (the option Leave Database
Operational. No Additional Transaction Logs Can Be Restored was selected)
If the only backup available is the last Full backup, is it possible to ever
roll back some of the last changes made in the old machine before the Full
Backup ?
Thanks for your help.If all you have is the full backup and the old db is toast then no. You
might be able to do something with third party tool help such as Lumigent
Log Explorer depending on a few factors.
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:%23xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi,
You can do this only if your OLD database is in "FULL" recovery model. Below
steps are under the assumption
that database was set to FULL recovery model and the existing database is
still up.
1. In the new server Load the full database backup with NORECOVERY
2. Perform a transaction log backup in Old Server.
3. Copy the TX log backup file to new server
4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
Books online)
This will allow you to go back to old data based on the date and time.
Note:
If it is Simple or Bulk_logged recovery model you cant rollback.
POINT-IN-TIME recovery is not supposed in both.
Thanks
Hari
MCDBA
<--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi Hari,
Unfortunately, my old server's HD is no longer is functioning. And all I
have is the last Full Backup. Looks like I may not be able to rollback any
changes...
Can you confirm?
Thanks.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> You can do this only if your OLD database is in "FULL" recovery model.
Below
> steps are under the assumption
> that database was set to FULL recovery model and the existing database is
> still up.
> 1. In the new server Load the full database backup with NORECOVERY
> 2. Perform a transaction log backup in Old Server.
> 3. Copy the TX log backup file to new server
> 4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
> Books online)
> This will allow you to go back to old data based on the date and time.
> Note:
> If it is Simple or Bulk_logged recovery model you cant rollback.
> POINT-IN-TIME recovery is not supposed in both.
> Thanks
> Hari
> MCDBA
>
>
>
> <--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> made
selected)
> ever
Full
>|||You will not be able to rollback any changes, as Hari pointed out you can
only do point in time recovery by using the tran log
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> Unfortunately, my old server's HD is no longer is functioning. And all I
> have is the last Full Backup. Looks like I may not be able to rollback
any
> changes...
> Can you confirm?
> Thanks.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Below
is
was
> selected)
to
> Full
>|||Hi,
If you dont have the old database active, Sorry, you will not be able to
rollback the transactions (POINT-IN-TIME).
Thanks
Hari
MCDBA
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:#vsd8lFBEHA.1600@.tk2msftngp13.phx.gbl...
> You will not be able to rollback any changes, as Hari pointed out you can
> only do point in time recovery by using the tran log
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> <--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> any
> is
(refer
> was
> to
the
>