No Transactions

[keene Scouser]

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?


thanks,
Brian

[Brian Donahue]

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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521