Warning 220: No log files found to be restored.

zajzaj Posts: 8
edited April 12, 2015 9:31PM in SQL Backup Previous Versions
Hello there,

I had setup a Log shipping plan. For some reason I had to reinstall my Source database server's OS. Now I get this error which I have posted below. Can somebody please help me to get back to my previous log shipping backup.

SQL Backup log file 7.7.0.7

-SQL "RESTORE LOG [poreport] FROM DISK = '\192.168.0.9 estLOG_po_*.sqb' WITH ERASEFILES = 3, FILEOPTIONS = 1, STANDBY = 'C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackupUNDO_poreport.dat', DISCONNECT_EXISTING,
MOVETO = 'C:ProcessedBackups' "
ERRORS AND WARNINGS


4/11/2015 1:35:00 PM: Warning 220: No log files found to be restored.
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    On the server where the restore is failing, could you run the following in Management Studio:
    EXEC master..sqlbackup '-sql "RESTORE SQBHEADERONLY FROM DISK = [\192.168.0.9	est<filename>] "'

    Replace <filename> with a name of any of the transaction log backup files on \192.168.0.9 est you expected SQL Backup to restore.

    If SQL Backup was able to read the header of the backup file, could you post the results here? Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.