Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

Restore DB - SQL Server 2000
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


Report this thread to moderator Post Follow-up to this message
Old Post
darren.daniel@iclployalty.com
03-01-06 01:23 AM


Re: Restore DB - SQL Server 2000
So ,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
>



Report this thread to moderator Post Follow-up to this message
Old Post
Uri Dimant
03-01-06 01:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 06:11 AM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006