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

    Default SQL Restore into + apply logs

    Hi guys,

    one question. Using TDP SQL 5.2.1.6 (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!

    Regards,
    Chris

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

    Default

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

    http://adsm.org/forum/showthread.php...store-Question

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
  •