Post reply

Point in time recovery for new database.

  • September 23, 2011 at 7:47 am

    #248588

    Experts,

    I know and have a done a point in time recovery with most recent Full backup and all the log bkps taken after the full backup. I have a doubt. May be I am confused.

    Suppose I created a database in the morning say at 10 AM.

    Now I added some records at 10.15 AM.

    Accidently deleted few records at 10.30 AM.

    DID NOT BACKUP THE DATABASE AT ALL SINCE IT'S CREATED IN THE MORNING.

    My question is that, Can we revert the deletion ?

    Is it possible to recover the data as at 10.15 AM ? (Without using any 3rd party tool....)

    ..... or Am I asking if a point in time recovery is possible with a FULL BACKUP... 🙂

    Thansk in advance.

    San

  • September 23, 2011 at 7:50 am

    #1385740

    You could if you had a full before the incident. Because then you could take a log backup and do the PIT restore.

    Right now you're hosed without 3rd party app.

    Edit : Assuming any app can help you here. Don't know that part.

  • September 23, 2011 at 7:51 am

    #1385743

    Nop. You have no backup, therefore you have no recovery options at all.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 23, 2011 at 7:56 am

    #1385752

    Thank you all for the quick responses.

    Had I taken atleast a full backup, I could have taken the tail log backup and do a PIT recovery, right ?

    Thanks again.

  • September 23, 2011 at 7:58 am

    #1385757

    Joy Smith San (9/23/2011)

    Thank you all for the quick responses.

    Had I taken atleast a full backup, I could have taken the tail log backup and do a PIT recovery, right ?

    Thanks again.

    Yes

  • September 23, 2011 at 8:03 am

    #1385763

    Joy Smith San (9/23/2011)

    Had I taken atleast a full backup, I could have taken the tail log backup and do a PIT recovery, right ?

    If the database was in full recovery model, yes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply