Transaction Log Rollback

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • m3ckon
    #1

    Transaction Log Rollback


    If someone could help me with this I will be in debt to you!

    I am a .net developer who is working on a system that has a sql server
    2000 backend. On the weekends, I work from home and I have MSDE on my
    laptop. This morning I went to update the main SQL server as I added
    some new views .. however I managed to import the data too!!

    Therefore I have overwritten my local data to the main sql server
    database, which has ressulted in loss of loads of work!

    Can I rollback to the version before I exported my data from MSDE to the
    main SQL server. I did the export by using enterprise manager and right
    clicking on the table on my local msde and then sending it to the real
    sql server!

    Please please please help??


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • Simon Hayes
      #2
      Re: Transaction Log Rollback


      "m3ckon" <anonymous@devd ex.com> wrote in message
      news:414568e9$0 $26153$c397aba@ news.newsgroups .ws...[color=blue]
      >
      > If someone could help me with this I will be in debt to you!
      >
      > I am a .net developer who is working on a system that has a sql server
      > 2000 backend. On the weekends, I work from home and I have MSDE on my
      > laptop. This morning I went to update the main SQL server as I added
      > some new views .. however I managed to import the data too!!
      >
      > Therefore I have overwritten my local data to the main sql server
      > database, which has ressulted in loss of loads of work!
      >
      > Can I rollback to the version before I exported my data from MSDE to the
      > main SQL server. I did the export by using enterprise manager and right
      > clicking on the table on my local msde and then sending it to the real
      > sql server!
      >
      > Please please please help??
      >
      >
      > *** Sent via Developersdex http://www.developersdex.com ***
      > Don't just participate in USENET...get rewarded for it![/color]

      If I understand you correctly, you've replaced the data in one single table
      on the main server with the data from your laptop? The best solution is
      probably to restore the database from a recent backup. If you only have full
      database backups, then you can only restore to the time of the backup, so
      you would lose any changes since then. If you also have transaction log
      backups, then you should be able to restore to the point in time just before
      you updated the table - see "Recovering to a Point In Time" in Books Online.

      Another option is to restore your backup to a completely new database, then
      copy the data from there to the target database. This may be better if you
      don't want to lose other database changes, and if you're sure that there
      will be no data integrity issues.

      Finally, if you have transaction log backups, then there are third-party
      tools which allow you to selectively roll back individual transactions:

      http://www.lumigent.com/products/le_sql.html


      Simon


        Comment

        Previous template Next
        Working...