Should script generation run for more than 12 hours?

Undo for SQL Server.

Moderator: eddie davis

Should script generation run for more than 12 hours?

Postby Dan825 » Wed Apr 04, 2007 3:38 pm

I was not able to find out how long the "Generating Script" process should take. I was able to attach to the log file backup and see the Drop Table statements, select them, and run though the "Undo Operations" dialog.

Since then the Generating Script window has been showing the progress bar that has been running close to an hour now, and I just wanted to check on how long I should expect this to run. It appears to still be processing according to the bar.

I easily had close to 100 "Drop table" statements selected so I figured it would take some time, just not sure what is normal.

File Size--

MDF: 2GB
LDF: 512MB
TL BAK: 83KB

Thanks.
Dan825
 
Posts: 2
Joined: Wed Apr 04, 2007 3:22 pm

Postby Dan825 » Thu Apr 05, 2007 2:38 pm

The answer is no. I let the scrip generation run though 24 hours, and then stopped it, selected less that the 100+ table drops and was able to return the script running fewer table drops the next time around.
Dan825
 
Posts: 2
Joined: Wed Apr 04, 2007 3:22 pm


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests