Rolling back a SQL server 2005 database.

9860 pts.
Tags:
SQL Server 2005
SQL Server administration
SQL Server database
SQL Server Rollback
We need to roll back a copy of our database 5 hours. We are running sql 2005 on a windows 2003 server. How can we do this? We do not want to effect production data but want to report against the 5 hour old data.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will need to restore the most recent full backup, then the log backups from the time the full was taken until the time you want to stop at.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • The Most-Watched IT Questions: November 2, 2010 - ITKE Community Blog
    [...] 1. Mr. Denny provided some guidance for rolling back a SQL server 2005 database. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: