• GilaMonster (12/4/2014)


    NO!

    If you mean a file backup of the log, that will trash your database. DO NOT ever restore database files from a file backup unless you know exactly what you're doing (and even then don't.)

    Sorry, I wasn't very clear in my statement. We actually tried restoring the entire database and transaction log from a backup. In talking more with the department that utilizes this database, I found that as far as end users are concerned, it's basically a read-only database for a front end web application. The data gets loaded nightly, fresh, from flat-files generated from an application that runs on an Alpha server. The users write no data to the database via the app, so it wasn't a problem to just try going back a ways and restoring the whole unit, to see if it resolved the issue.

    That said, still getting that same error from my prior reply, so still working with it some more.