---21:57
backup database northwind to disk=N'D:/northwind_full.bak'
-----22:01
use northwind
update orders set shipname='1'
Backup log northwind to disk= N'D:/20091226_log.bak'
restore LOG northwind from disk= N'D:/20091226_log.bak', STOPAT = '2009-12-27 22:00'
backup database northwind to disk=N'D:/northwind_diff.bak' with differential
-- Restore the database backup.
restore database northwind from disk= N'D:/northwind_full.bak' WITH NORECOVERY
GO
restore LOG northwind FROM disk= N'D:/20091226_log.bak' WITH RECOVERY
GO
restore LOG northwind FROM MyNwind_log2 WITH RECOVERY, STOPAT = 'Jul 1, 1998 '
restore northwind with recovery
go