Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

How to restore lost data in SQL server 2000 ?

while performing archival activity, one of my colleague mistakenly dropped one column  from one production table which has caused at least 450000 values of a column to be lost. We have full backup of database taken at morning 7 AM. Event has occured at 2:30 PM. Please suggest how to restore data till the last moment of that event ? Is it possible from log to restore it upto that point ?
0
Prasenjit_Dutta
Asked:
Prasenjit_Dutta
  • 3
  • 3
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I would restore the db under a second name to the point of time before the drop column.
then, add the column to the table in your prod table.
then, with a UPDATE based on the primary key, get the values back from the restored db:
UPDATE t
  SET column_name = b.column_name
 FROM yourprod_db.dbo.table_name t
 JOIN yourrestored_db.dbo.table_name r
   ON r.primary_key = t.primary_key

Open in new window

0
 
Prasenjit_DuttaAuthor Commented:
Hi Angel,
Thnks for ur reply. But I do not know how to restore database to the point ot time before the drop column
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
let's start by reading the support note:
http://msdn.microsoft.com/en-us/library/ms190982.aspx
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Anthony PerkinsCommented:
And hopefully your database has Full Recovery model and not Simple or you will be SOL
0
 
Prasenjit_DuttaAuthor Commented:
Yeah, my database has full recovery model
0
 
Anthony PerkinsCommented:
Then follow the link posted by angelIII
0
 
Prasenjit_DuttaAuthor Commented:
sorry for replying late. Thanks to you for your prompt help on the issue.
0
 
Anthony PerkinsCommented:
I am not sure what I did yo help.  Feel free to post a message in CS to have the points re-allocated.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now