We had implemented the logshipping in our server, now we found the curious thing:
the logshipping job was all successful, the logshipping monitor also showed successful.
But checking the restore log in the logshipping monitor, still found the following issue:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\oadb_tlog_201009010000.TRN'. Device error or device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.
We have no idea whether the logshipping was successful or not. But if not, why the restore job was successful and also shows the error?happyMan
View Complete Post