Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007

    Unanswered: Restore point in time

    Hi there,

    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):
    restore log MyDatabase with  STOPAT = '2011-12-01 11:11:42.000', RECOVERY;
    The reason for this would be easier restore procedure (external tool to customize)

  2. #2
    Join Date
    Nov 2011
    Here is good script to generate SQL restore commands.

    Auto generate SQL Server database restore scripts

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts