Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI´m having a problem when trying to restore log backups. After i had restored my Data backup leaving it able to restore aditional tra nsaction 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 s pecifc point in time. I´m utilizing the following statment to restore the fi le 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.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread