Post reply

Point in time recovery

  • September 23, 2008 at 9:25 am

    #193391

    Had to do a point in time recovery on a client site,

    had a full backup of last night, and then one transaction log backup for yesterday night and one for today,but before the transaction log is backed up(today morning), the sql server services were restarted by them and when i tried to do a point in time recovery, it was throwing an error.

    I was trying to restore it as a new database.

    Does the point in time can not be done if there is a restart of services, or I cannot restore it to a new db.

    Thanks for the help.

  • September 23, 2008 at 9:29 am

    #875813

    Can you post the restore commands you were using? I have done point in time restores to a new database.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 23, 2008 at 9:29 am

    #875814

    What was the error it was giving?

    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, 2008 at 9:32 am

    #875819

    I was doing it with SSMS and the error was invalid value for STOPAT, something like that.

    The issue is resolved now, as we have found the actual reason for the application to freeze and resolved it.

  • September 23, 2008 at 9:35 am

    #875820

    I missed it, the client was on SQL2000.

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

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