Trying to troubleshoot issues

Undo for SQL Server.

Moderator: eddie davis

Trying to troubleshoot issues

Postby sunbaked » Thu Oct 19, 2006 3:01 pm

Hi. When i trialed SQL Log Rescue i seemed to get exactly what i needed, now that i have purchased it though i can't seem to get anything - i am not sure if i am doing something different this time or if there is some other issue.

I have an application in production at a client site but am having some weirdness i am trying to troubleshoot. I have backed up both his database & transaction files (180MBs, 5.2GBs respectively). I restore the database on my development server and then start a new project. I point to both the bak file & the trn file when prompted and they are accepted and i am free to process the logs.

Next step though it tells me "No transactions are recorded in the database log. Re-run the Project Settings wizard..."

The client's production server does not have your application running on it, i am not sure if that makes the difference? I am looking for a product to analyze the backup (db & trn) to evaluate - is this maybe not the product for me or am i missing something simple?

TIA
sunbaked
 
Posts: 8
Joined: Thu Oct 19, 2006 2:51 pm

Postby Brian Donahue » Fri Oct 20, 2006 12:15 pm

Hello,

If you have an offline server available to restore the database to and a full set of full and transaction log backups, then you should probably use log rescue offline rather than in your production environment. The full procedure for doing this is descussed here:

http://www.red-gate.com/messageboard/vi ... php?t=1993

The procedure is laid out in the second post to this topic, before the topic goes off in other directions.
Brian Donahue
 
Posts: 6669
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

cron