Tuesday, March 20, 2012

Restoring Database to a previous point of time --Recommended for all DBA's

The scenario


A coworker calls you in a panic because he accidentally deleted some production data, and he wants you to restore the lost records.

Read further

http://www.techrepublic.com/blog/datacenter/restore-your-sql-server-database-using-transaction-logs/132

Preferable:

http://www.linglom.com/2009/07/03/solved-system-data-sqlclient-sqlerror-the-tail-of-the-log-for-the-database-dbname-has-not-been-backed-up/

3 comments:

profitscouter said...

Reblogged this on elektronischer bundesanzeiger.

Restoring Accidentally deleted or Updated Rows without Backup restore – Sql Server « SSIS and Sql Server Journey said...

[...] In Reference to my previous post : Restoring Database to a previous point of time –Recommended for all DBA’s [...]

ownerdba said...

buen blog

visital el mio

http://dbasqlserver.wordpress.com/

saludos