Options

No Transactions

keene Scouserkeene Scouser Posts: 2
edited January 4, 2006 1:22PM in SQL Log Rescue
When trying to create a new project, I get an error stating that no transactions are recorded in the database log. Make sure you have the correct Database and Server combination. (which I do)

Log Rescue reports that it found no problems with the backup file but I cannot create a project against this database.

I can create projects against other DB's on the same server that are setup in exactly the same way.

Any ideas?
:cry:

thanks,
Brian
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Brian,

    If the database is not using the simple recovery model and the recovery model hadn't changed since the last full backup, then you should see all of your transactions.

    Another possibility is that you'd truncated the log after a log backup. In that case, you should see them if you include the log backups in the backup files list along with the full backup files.

    Hopefully this is the issue here.
    · Share on Twitter
This discussion has been closed.