469,923 Members | 1,519 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

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!
Jul 20 '05 #1
1 8708

"m3ckon" <an*******@devdex.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

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!


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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Brent Mondoux | last post: by
2 posts views Thread by Dano | last post: by
1 post views Thread by REB | last post: by
9 posts views Thread by ucasesoftware | last post: by
1 post views Thread by jacob.miles | last post: by
3 posts views Thread by Steven Blair | last post: by
6 posts views Thread by mcmc | last post: by
4 posts views Thread by Aamir Mahmood | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.