Post reply

Is it possible to restore to a point in time by starting with current db and rolling back t logs?

  • May 26, 2017 at 5:57 am

    #338003

    The scenario is that I have a log-shipped database and a user has dropped a table.  

    Rather than starting with the last full backup and restoring logs to a point in time, I would like to start with my existing database and rollback transaction logs to a time before the table drop.

    Is this possible?  We are using version 2014, by the way.

    Thanks

  • May 26, 2017 at 6:04 am

    #1944311

    No.

    You need to start with a full backup from before the table was dropped and roll forward.

    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

  • May 26, 2017 at 6:10 am

    #1944312

    Thanks for the response.  It was wishful thinking.

Viewing 3 posts - 1 through 2 (of 2 total)

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