Home > IT Answers > SQL Server > Rolling back a SQL server 2005 database.
Karl Gechlik
9,815 pts.
 Rolling back a SQL server 2005 database.
SQL Server 2005, SQL Server administration, SQL Server Database Rollback, 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.

Software/Hardware used:
ASKED: October 22, 2010  5:33 PM
UPDATED: October 23, 2010  11:46 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  October 23, 2010  11:46 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _