Post reply

Backup and restoration scenario need perfect answer

  • December 7, 2013 at 8:24 am

    #287338

    Dear all

    scenario

    sunday - mon - tues - wed - thur - frid - sat - sunday

    full - diff - diff - diff - diff - diff - diff - full

    At tueday and 1.10- 1.30pm transactional log contains tlog1 tlog2 etc and

    data is not crashed or disaster not occured but Client want to get the data full [full from sunday] upto tuesday 1.30 pm how will you restore the database.

    Thanks
    Naga.Rohitkumar

  • December 7, 2013 at 8:53 am

    #1671724

    What do you think is the solution? By the way, there is no perfect solution.

  • December 7, 2013 at 10:00 am

    #1671726

    no log backups?

    ---------------------------------------------------------------------

  • December 7, 2013 at 1:10 pm

    #1671737

    naga.rohitkumar (12/7/2013)

    Client want to get the data full [full from sunday] upto tuesday 1.30 pm how will you restore the database.

    Can't be done. If the client wants point in time restore, then the DB has to be in full recovery, not simple which it appears to be in from that backup strategy and there need to be regular log backups.

    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 4 posts - 1 through 3 (of 3 total)

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