Restaure jusqu'à un point

**agdid04** · 09/01/2017, 15h55

Bonjour,

La dernière étape d'une restauration:

Code :

1
2
3
4
Restore LOG MABASE from
DISK='H:\BACKUP\MABASE_backup_20170109120504_5615514.trn' 
WITH RECOVERY STOPAT = 'January 09, 2017 11:45 AM';
GO

Me remonte ce message d'erruer:

Code :

1
2
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'STOPAT'.

Merci.

@+

**SQLpro** · 09/01/2017, 18h58

Code :

1
2
3
Restore LOG MABASE 
from DISK='H:\BACKUP\MABASE_backup_20170109120504_5615514.trn' 
WITH STOPAT = 'January 09, 2017 11:45 AM', RECOVERY;

Manquait la virgule !

A +

**agdid04** · 10/01/2017, 10h21

Bonjour,

Merci beaucoup.

@+

Administration SQL Server