I have a problem about restore job. It is not working. When i read logs it says;
xxxx.trn failed to open. Operating system error 2(failed to retrieve text for this error. Reason: 15105).
When i tried to find the trn file that sql server is looking for, that trn log is not in the directory where all my trn log files are. Also, According to log files, there is a gap between transaction logs. I tried to restore manually, but it still did not work. Moreover, there is a strange problem here. Because once i run this query which finds the latest trn log that has been restored;
select distinct r.destination_database_name, r.restore_date,
bs.server_name, m.physical_device_name as backup_device, b.physical_name
from msdb.dbo.restorehistory r
inner join msdb.dbo.backupfile b on r.backup_set_id = b.backup_set_id
inner join msdb.dbo.backupset bs on b.backup_set_id = bs.backup_set_id
inner join msdb.dbo.backupmediafamily m on bs.media_set_id = m.media_set_id
ORDER BY restore_date DESC
However, in the directory, date modified is 04:15 for this BPSDB_20140122021505.trn . Thus I could not restore it manually. IDK what is going on ?
FYI, i make databases up to date by restoring from ibm tivoli.
Thanks in advance