SQL Restore into + apply logs

[cmoeller]

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

[GregE]

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