Restore point in time

Alren · #1 (**permalink**) 12-01-11, 07:55

Hi there,

In there a t-sql statement that permits to load all the backups and log files in NORECOVERY and AFTER

I was thinking of something like this (incorrect syntax)
<code>restore log TestRestore with STOPAT = '2011-12-01 11:11:42.000', RECOVERY;</code>

randirsa · #2 (**permalink**) 12-01-11, 12:17

http://www.mssqltips.com/sqlserverti...store-scripts/

Alren · #3 (**permalink**) 12-05-11, 03:32

This article is +/- what I want to do except that I'd like to do a point in time restore.
Instead of the line

Code:

SELECT 999999999 AS backup_set_id, 'RESTORE DATABASE ' + @databaseName + ' WITH RECOVERY'

I would like something that did a point in time (if this is possible)

Thanks for your reply
Alren

randirsa · #4 (**permalink**) 12-05-11, 07:57

it seems you have missed the backup location .
This is syntax for restoring point in time.

RESTORE LOG AdventureWorks2008R2
FROM AdventureWorks2008R2Backups
With NORECOVERY, STOPAT = 'Apr 15, 2020 12:00 AM';

RESTORE DATABASE AdventureWorks2008R2 WITH RECOVERY;

Alren · #5 (**permalink**) 12-05-11, 08:21

Thanks
This answers my question.

Alren

Internet Services

Web Development

Digital Marketing

Consumer Tech