Recover data with updated transaction Log only

From: Thomas Tsang (thomast_at_hkc.net)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 19:03:40 +0800

I am newbie in MS SQL Server, today I wrongly run a script to clear all data of a table, and the backup is one month ago. Can I just use the existing transaction log to rollback what I have done today? If yes, how to do so.

The data is very important, please help.

Regards,
Thomas

Relevant Pages

  • Re: Script to stop a SQL service
    ... > Would the syntax be the same if I ran the command line script from within ... > I'm planning on running this batch file from within the BackUp Exec ... backup SQL Server databases online. ...
    (comp.databases.ms-sqlserver)
  • Re: backing up SQL server
    ... Please go thu the script will take the UNC path as the parameter and will ... Backup Master, MSDB and all the User databases to the remote machine. ... can I reinstall and configure SQL server and then restore the ...
    (microsoft.public.sqlserver.server)
  • Re: Delete table data
    ... It might be best to script out all the objects, drop the db and recreate it ... Just make sure to have a backup and make sure you script out all the ... > Is there any easy way to clear all table data for a SQL server database? ...
    (microsoft.public.sqlserver.setup)
  • Re: Timeout errors
    ... Just my 2 cents, I faced a similar problem sometime ago: ... I would try to backup my SQL Server DB (not from a script, ... drive on the SQL Server ...
    (comp.databases.ms-sqlserver)
  • How do I call a stored procedure using perl DBI and evaluate the output
    ... I'm trying to run sp_dbcmptlevel @dbname='master' from within a perl ... script. ... I'm a newbie to sql server so I may be missing something very basic. ...
    (microsoft.public.sqlserver.programming)
Loading