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
RegardsRESTORE
bcp out|||hi thanks for the reply
Can u be more specific as i am very new to this database
TIA
Regards|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment