No Transactions

Undo for SQL Server.

Moderator: eddie davis

No Transactions

Postby keene Scouser » Tue Jan 03, 2006 9:16 pm

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
keene Scouser
 
Posts: 1
Joined: Tue Jan 03, 2006 9:11 pm

Postby Brian Donahue » Wed Jan 04, 2006 7:22 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests