Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: restoring single table

    Hi All,

    I am taking transaction log backup every six hours. Now i want to restore just one particular table before 2 hrs of now.
    How can i go about pls help me as its very urgent.

    TIA
    Regards

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    RESTORE

    bcp out
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115
    hi thanks for the reply

    Can u be more specific as i am very new to this database

    TIA
    Regards

  4. #4
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You can restore the database to a second instance of the database and then DTS or use BCP to send the table over to your live database. If you are new I would reccomend using the DTS import/export wizard (remember to delete destination rows).

    The other way is you could buy a third party tool called lumigent log explorer that would allow you to do this without restoring.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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