What are the challenges you face when working across database platforms? Take the survey

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

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


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


  • Options
    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 = [\	est<filename>] "'

    Replace <filename> with a name of any of the transaction log backup files on \ 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
Sign In or Register to comment.