"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