Error While Restoring …. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error While Restoring ….

Hi I am facing following errors while restoring a backup file. "The backup set in file ‘D:M3PBM3PB Complete Backup.bak’ was created by BACKUP LOG
connot be used for this restore operation.
Restore Database is terminating abnormally."
Urgent Please. Thanks, raj
The file you are trying to recover is a log backup not a full database backup. you must restore the full database backup first – you can then apply logs if you wish to do so.
from EM, right click DB, all tasks > restore . This wil show you what all FUll backups available,
and correspondng logs to be restored. Just an easy way

or you can use <br />restore filelistonly from backupdevice to find out if its full database / database file or logfile only<br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />