Re: Recovery from Delete statement using the transaction logs
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/17/05
- Next message: Yogish: "Re: SQL Server slows down after 1-2 hours"
- Previous message: Robert: "Recovery from Delete statement using the transaction logs"
- In reply to: Robert: "Recovery from Delete statement using the transaction logs"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 17 Feb 2005 16:11:24 +0100
I assume you didn't protect the delete with BEGIN TRAN? If you did, just do ROLLBACK.
Are you performing regular transaction log backups? Is database in full or bulk logged recovery
mode? If answers to these questions are "no", you will probably need to go to your most recent
backup or just accept the data loss. If answers are "yes", you *might* be in better shape.
Anyhow, I suggest you read my article on the topic at:
http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Robert" <robert@expressprogramming.com> wrote in message news:179b01c51500$f58a6c00$a601280a@phx.gbl... >I ran some delete statements in Query Analyzer and I > found out it was the wrong database. Can you rollback the > delete statements and recover the data from the > transaction logs????
- Next message: Yogish: "Re: SQL Server slows down after 1-2 hours"
- Previous message: Robert: "Recovery from Delete statement using the transaction logs"
- In reply to: Robert: "Recovery from Delete statement using the transaction logs"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
