SQL Server Performance Forum – Threads Archive
Restoring databaseFolks, 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! ——————
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…
The only way to use the 3rd party tool?
we could not be able to use SQL Server utilities? ——————
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