| Renato Machado 2006-03-31, 1:49 pm |
| I´m having a problem when trying to restore log backups.
After i had restored my Data backup leaving it able to restore aditional transaction logs, i start the commands to restore my log backups:
RESTORE LOG [ACS]
FROM DISK = N'D:\BACKUPTRABALHO\
acs\BKP_ACS_LOG'
WITH FILE = 24, NOUNLOAD , STATS = 10, STANDBY = N'D:\BACKUPTRABALHO\
ACS\UNDO_ACS.DAT'
The files are between 24 and 32, but the file 32 I want to restore until a specifc point in time. I´m utilizing the following statment to restore the file 32:
DECLARE @DATA DATETIME
SET @DATA = '2006-03-22 00:00:00'
RESTORE LOG [DB_ACS]
FROM DISK = N'D:\BACKUPTRABALHO\
ACS\BKP_ACS_LOG'
WITH FILE = 32, NOUNLOAD, STATS = 10, RECOVERY,
STOPAT = @DATA -- '2006-03-22 00:00:00'
The result of the execution of the statemment above is:
Deleting database file 'D:\BACKUPTRABALHO\A
CS\UNDO_DB_ACS.DAT'.
11 percent restored.
20 percent restored.
30 percent restored.
40 percent restored.
50 percent restored.
61 percent restored.
70 percent restored.
80 percent restored.
90 percent restored.
100 percent restored.
Processed 601 pages for database 'DB_ACS', file 'web_Log' on file 32.
Server: Msg 3624, Level 20, State 1, Line 4
Location: recovery.c:2545
Expression: IS_OFF (DBT_RDONLY, m_dbt->dbt_stat)
SPID: 52
Process ID: 1160
Connection Broken
Someone can help me about this error message, or if i´m doing anything wrong?
Thanks
Renato. |