Home Forums SQL Server 2005 Backups The database cannot be recovered because the log was not restored. RE: The database cannot be recovered because the log was not restored.

  • August 10, 2012 at 12:24 am

    #1524223

    before restoring backup check following...

    restore verifyonly from disk ='E:\bk_full_datacenter\test1.bak' --The backup set on file 1 is valid.

    restore labelonly from disk ='E:\bk_full_datacenter\test1.bak'-- media related information

    restore filelistonly from disk ='E:\bk_full_datacenter\test1.bak'--list filegroups in backup

    restore headeronly from disk ='E:\bk_full_datacenter\test1.bak' --see compatiblity level and software version

    then try to restore backup..