Post reply

Point in Time Restore in disabled

  • March 12, 2004 at 11:52 am

    #82244

    I have SQL 2000 running on my machine. i was testing some query and unfortunately i have updated all the records of one table. that occur at 03/12/2004 12:30 Pm. i have the backup file of dated 03/11/2004 10:00 pm

    so i first restored that. now i want to apply transaction log till 03/12/2004 12:29 Pm. But the check box to select this Point in Time restore method is disabled.

    Anywant know how i can make this enable and specify the time so i can apply the latest transaction log.

    Any suggestion related to this will be highly appreciated.

    Thanks

     

  • March 12, 2004 at 1:04 pm

    #498595

    Your database was in full recovery mode?

     


    Shamless self promotion - read my blog http://sirsql.net

  • March 23, 2004 at 12:53 pm

    #500101

    Yes

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

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