473,287 Members | 1,555 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

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 8819

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Brent Mondoux | last post by:
Hey everyone, I have a set of stored procedures that call each other to perform a set of tasks. I have decided to do this for database performance reasons rather than doing it from a ColdFusion...
1
by: Jason Huang | last post by:
Hi, I am just wondering how do we test the transaction's Commit and Rollback? How do we simulate a situation to let the transaction fail then Rollback? Thanks for help. Jason
2
by: Dano | last post by:
Hi all! Perhaps a wise soul can help me here. I have an insert routine for an ASP.Net application and it works fine, but I decided to test the transaction rollback capabilities by stopping the...
1
by: REB | last post by:
If I create a transaction object for rolling back a insert query in the on click event of a form button can the transaction be tracked across other functions? For example: private void...
9
by: ucasesoftware | last post by:
i need to use this : Private Shared Sub Demo1() Dim db As SqlConnection = New SqlConnection("connstringhere") Dim transaction As SqlTransaction db.Open transaction = db.BeginTransaction Try...
1
by: jacob.miles | last post by:
Hello. I'm trying to wrap a function call in a transaction, but when I intentionally throw an exception in the middle of the function it doesn't actually roll back the transaction. The debug...
3
by: Steven Blair | last post by:
I have a problem on my SqlDataSource. Once my SqlDataSource has Inserted, I need to run a stored procedure. The return from this stored procedure determines if Icommit or rollback. Here is my...
6
by: mcmc | last post by:
I have the following piece of code: transaction = session.create_transaction() try: # Do some work here that might fail p=P() p.ID=333 session.save(p) session.flush() ...
2
by: NarutoFanatic | last post by:
Hello, I'm having trouble using a transaction - rollback statement in sql. I can't seem to have the rollback executed during an error when i've altered a table to add a column with the same name...
4
by: Aamir Mahmood | last post by:
Hi I am using System.Transactions.TransactionScope to implement the transactions in my code. When the transaction is rolled back because of any reason, I want all the objects that were...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.