How to restore SQL Server database to a particular time?
You can do it through T-SQL this way:
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK' 
WITH NORECOVERY
GO 
RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN' 
WITH RECOVERY, 
STOPAT = 'Mar 23, 2009 05:31:00 PM' 
GO

But don't forget you can use the GUI from SSMS. The graphical solution is easier to understand especially if you are 4 people around the same monitor and the manager is behind you with a stick in his hand:

Right click on the database &gt; Tasks &gt; Restore &gt; Database



General &gt; Timeline and setup the time for database restoration



Check in “Specific date and time” to set up the time for database restoration, press “OK” to save changes, and press “OK” button in the previous window