Category: SQL Server

26 Apr 2016 05:09

Joined:	12/02/2013
Level:	Silver
Points:	147

Points:	2

Have to recover updated data.

Hi friends,

1. I updated a table with some wrong data, here around 5000 data were updated. I updated it without giving commit. Is it possible to recover the previous data?

2. And how can i copy data from one server to another server?

Any idea?

Thanks in Advance

#765673

26 Apr 2016 22:22

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	3

1. If you are using transaction you can easily revert back. It is depending on the isolation level which you are using
If you want more details about the isolation level, please go through the following article.

https://msdn.microsoft.com/en-IN/library/ms173763.aspx

2. Are you asking about SQL Server
You can take backup and restore
You can use Import/Export function
Just copy the .MDF and .LDF files and attach and create database

By Nathan
Direction is important than speed

#765675

26 Apr 2016 22:57

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	4

1. If you are not using transaction then it is pretty difficult to get the data back.
2. to transfer data from one server to another see below steps
- if you want to transfer whole database then you can copy MDF file to another server and attached there directly
- if you want to copy only table with data then you can use script for that.
you can use Backing up/Exporting database also.
There are two ways to Back up/Export a SQL Server database using SQL Server Management Studio:
1.Right click database ? Tasks ? Generate Scripts ? Choose DB ? Change "Script Data" option to true ? …
2..Right click database ? Tasks ? Backup ? ...
If we have a .sql file and it's not too big we can just open it with SQL Server MS and run it.
If we have a .sql file but it's too big to be opened with SQL Server MS we have to use sqlcmd like this:
>sqlcmd -i C:\panels_QA28July11.sql -o C:\PanelsImportResult.txt
see below link for more detail
http://blog.sqlauthority.com/2012/07/18/sql-server-generate-script-for-schema-and-data-sql-in-sixty-seconds-021-video/

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

#765689

27 Apr 2016 05:36

Joined:	14/04/2016
Level:	Silver
Points:	118

Points:	2

Hi,

Using SQL server profiler you can get the details of the query which you have fired.But cant rollback unless you have used transaction.

Hope it helps!!

#765701

27 Apr 2016 23:36

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	2

Hi Murugesan,

1) If you are using Transactions you can able to get back the data by using logs.

2) If you want to copy one server data into another server then get the backup of first server and copy the same in your desired server.

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#766519

17 Jun 2016 02:41

Joined:	12/12/2013
Level:	Gold
Points:	529

Points:	4

Hi,
Ans for Updating Question,
1. I'm also faced this issue. But i tried lot. I can't get the original data which is having before the Updation. If you have backup of the database means you just simply restore and get those data's from there. Other Wise you won't. And One More thing Here after, without begin transactions and commit/ rollback you never execute the Update query.
Ans for Copying the Data from One Server to Another Server,
2. You can the Linked server. If you add the Server into another Server it very easy to copying the data.
Use the Following statement:
Sp_AddlinkedServer "ServerName"

Regards,
Karunanidhi.K

#766879

28 Jun 2016 13:07

Joined:	20/03/2013
Level:	Gold
Points:	4230

Points:	2

The Original data will not get back if you don't use the transactions many programmers face this type of situations if you have back up the database then you can attach that database and use it,

SRI RAMA PHANI BHUSHAN KAMBHAMPATI

Have to recover updated data.

Email subscription

About dotnetspider.com

Quick Links

General

Services