Restoring database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restoring database

Folks, Suppose I had a full backup at 8AM, and only had one differential backup at 10AM, is it possible for me to restore database to 9AM? if yes, how to do it? Thanks in advance! ——————
Bug explorer/finder/seeker/locator
——————
thats the idea behind log backups look into the product below, and other comparable vendors http://www.lumigent.com/products/le_sql.html
You have to use STOPAT option but…
I don’t think STOPAT option is supported with differential restore…
MohammedU.
Moderator
SQL-Server-Performance.com
The only way to use the 3rd party tool?
we could not be able to use SQL Server utilities? ——————
Bug explorer/finder/seeker/locator
——————
I have had same problem and I have used Lumigent to sort this out as suggested by joechang. Check following thread…see if it’s help you http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19554 sonny
]]>