Results 1 to 2 of 2

Thread: partial restore of the database

  1. #1
    Join Date
    Jan 2006
    Location
    Hyderabad, India
    Posts
    26

    partial restore of the database

    we r using sql server 2000.wrongly we have updated 26,500 rows instead of 1 row. we have a backup for that database.
    how to restore the database up to a particular point as we have updated some 400 rows with correct data. now we want to restore the database for only 26,000 rows.

    please any body help us.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    If the db is in full recovery model, may log backup with no_truncate option. Then restore db from full backup to another name, apply log and stop at the point before running update statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •