Red Gate forums :: View topic - No Transactions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

No Transactions

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
keene Scouser



Joined: 03 Jan 2006
Posts: 1

PostPosted: Tue Jan 03, 2006 9:16 pm    Post subject: No Transactions Reply with quote

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?
Crying or Very sad

thanks,
Brian
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Wed Jan 04, 2006 7:22 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group