Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Thanked 0 Times in 0 Posts

    Default SQL Restore into + apply logs

    Hi guys,

    one question. Using TDP SQL (I know, not my choice here ...) on an older SQL 2005 server I need to restore a
    database to a specific point in time - as a copy! I know that's done by setting "restore into" and "relocate" options. But
    do I have to do this for all the log backups as well or is it enough to to this to the last "full" backup?

    Thanks for the info!


  2. #2
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Thanked 17 Times in 16 Posts


    Use the last full backup, but also use the /RESTOREDATE and /RESTORETIME parameters and that single command will restore everything.

Similar Threads

  1. SQL Truncate logs
    By tsmdumber in forum Microsoft SQL Server
    Replies: 1
    Last Post: 04-29-2011, 04:10 AM
  2. Replies: 2
    Last Post: 07-24-2009, 02:09 PM
  3. Replies: 3
    Last Post: 07-17-2008, 07:41 AM
  4. Can't shrink logs after DB restore (RELOCATE/RESTORE INTO)
    By blackminder in forum TDP/Application Layer Backup
    Replies: 3
    Last Post: 02-07-2008, 06:52 AM
  5. TDP for SQL 2005 - Truncate Logs?
    By evolving in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 03-21-2006, 03:09 PM

Posting Permissions

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