Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHi, I made a release on system at 12pm 22/02 and overwrote a table by mistake. I have a back from from the night before (12 at night) but from the time I did a backup and and the time I did the release some records would be lost. I want to recover the data lost. Can I examine the transaction logs to get back the data? What would I need to do? TIA, Darren
Post Follow-up to this messageSo ,have you done BACKUP LOG file? If yop do , just apply all log'd backups WITH NORECOVERY option except the last one Visit at Tibor's web site to find a greate example ,how to restore a database at point of time <darren.daniel@iclployalty.com> wrote in message news:1141131856.938247.59340@z34g2000cwc.googlegroups.com... > Hi, > > I made a release on system at 12pm 22/02 and overwrote a table by > mistake. > > > I have a back from from the night before (12 at night) but from the > time I did a backup and and the time I did the release some records > would be lost. > > I want to recover the data lost. > > Can I examine the transaction logs to get back the data? > What would I need to do? > > TIA, > Darren >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread