Transaction Log Rollback - Microsoft SQL Server

m3ckon

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

Subscribe Reply

8832

Simon Hayes

"m3ckon" <an*******@devd ex.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

Similar topics

6925

Stored procedure rollback

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 page (and to prevent timeouts, etc.) These stored procedures run every night and handle scheduled tasks in a complex system.

Microsoft SQL Server

10359

Testing Transaction Commit and Rollback in C# ASP.Net

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

C# / C Sharp

2618

Oh those Transaction Headaches!

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 SQL server when it was just about to insert the record (I use a breakpoint and then stop the server). What should have happened is that the...

ASP.NET

1333

Transaction object question

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 btnSaveDriver_Click(object sender, System.EventArgs e) {

ASP.NET

10926

Transaction with stored procedure

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 call (New SqlCommand("INSERT INTO TransactionDemo " + "(Text) VALUES ('Row1');", db, transaction)).ExecuteNonQuery

Visual Basic .NET

3008

SQLObject transaction rollback not working

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 output says 1/ROLLBACK, without any 1/COMMITs in there, but when I view the data in the command-line mysql utility the changes have been made. This...

Python

6682

Using a Transaction with a SqlDataSource

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 approach: http://rafb.net/p/b53pmq89.html When the ExecuteNonQuery is fired the following exception is thrown:

C# / C Sharp

6596

SQLAlchemy, flush vs. transaction

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() # Do some more work here that might fail

Python

11923

ROLLBACK ALTER column statement

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 (run the alter script twice on purpose to test the rollback). Somehow i got an error of the column should be unique (since the column already added...

Microsoft SQL Server

3664

Transaction Rollback and Object State

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 modified in the transaction scope to be in their initial (pre-transaction) state. Is there something already available in .net? Or some standard...

C# / C Sharp

7659

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7580

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8103

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

6244

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5481

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

5208

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3634

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2079

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

916

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General