SSIS and Sql Server Journey

Personal Notes of Sarabjit Singh and Bhavpreet Singh

Restoring Database to a previous point of time –Recommended for all DBA’s

on March 20, 2012

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/

Advertisements

3 responses to “Restoring Database to a previous point of time –Recommended for all DBA’s

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: