Post reply

How to rollback any partial database updation

  • March 2, 2007 at 5:26 am

    #153462

    We have a application which work on remote connection where front end is VB 6 and backend is SQL server 2000. We are facing problem of partial updation of tabels + link tabels due to system hanging or network break. Pl help me in such situation. How can we use TTS or rollback feature at SQL server end.

  • March 2, 2007 at 5:30 am

    #692806

    apply last backup and roll logs forward until point in time / last log backup.

    Failing that you may be able to recover using a log explorer type program, which you'll probably have to buy as most don't allow evals to work on user databases, for obvious reasons. This method is more painful!

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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