January 29, 2012 at 8:31 pm
I have statement and run it by SQL jobs
RESTORE LOG DB_SHOP FROM DISK = 'DB_backup_201201221250.trn' WITH FILE = 1, STANDBY = 'DB_backup_201201221250.bak', NOUNLOAD, STATS = 10
(1 row(s) affected)
14 percent processed.
31 percent processed.
49 percent processed.
66 percent processed.
Msg 3203, Level 16, State 1, Procedure s_res_translog_for_database, Line 70
Read on "D:\MSSQL_Backup\LOG\DB_backup_201201221250.trn" failed: 38(Reached the end of the file.)
Msg 3013, Level 16, State 1, Procedure s_res_translog_for_database, Line 70
RESTORE LOG is terminating abnormally.
Can you help me ?
thanks all
phuongnh
January 29, 2012 at 8:44 pm
Its seems the log backup file got corrupted.
January 29, 2012 at 9:40 pm
I do not think so
January 29, 2012 at 10:05 pm
nhphuong76 (1/29/2012)
I have statement and run it by SQL jobsRESTORE LOG DB_SHOP FROM DISK = 'DB_backup_201201221250.trn' WITH FILE = 1, STANDBY = 'DB_backup_201201221250.bak', NOUNLOAD, STATS = 10
Did you try this command to see whether your transaction log backup is valid.
restore headeronly from disk = 'DB_backup_201201221250.trn' with unload
---- babu
January 29, 2012 at 11:29 pm
miss copy, full path is D:\MSSQL_BACKUP\DB_backup_201201221250.trn
January 31, 2012 at 2:56 am
nhphuong76 (1/29/2012)
miss copy, full path is D:\MSSQL_BACKUP\DB_backup_201201221250.trn
Perform this on your backup file to ensure it is valid:
RESTORE VERIFYONLY FROM DISK = 'D:\MSSQL_BACKUP\DB_backup_201201221250.trn' WITH STATS = 1
If the result comes as valid, the backup file is intact.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply