var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Restore point in time
Is there a t-sql statement in SQLServer 2008 R2 that permits to load all the backups and log files in NORECOVERY and AFTER that issue a statement that allows point in time restore ?
I was thinking of something like this (incorrect syntax):
The reason for this would be easier restore procedure (external tool to customize)
restore log MyDatabase with STOPAT = '2011-12-01 11:11:42.000', RECOVERY;
Here is good script to generate SQL restore commands.
Auto generate SQL Server database restore scripts
Tags for this Thread