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
Showing posts with label hrs. Show all posts
Showing posts with label hrs. Show all posts
Subscribe to:
Posts (Atom)