Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database in recovering mode
Message
From
09/12/1998 16:02:34
 
 
To
09/12/1998 15:50:14
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00165703
Message ID:
00165780
Views:
26
Hi Michel ---

>>An error occured when processing one or more transactions, is what happened. Go to the Error Log from the Server menu in SQL Enterprise Manager to get more info on what happened.
>
>The log shows the entries during the last reboot. Some databases have been recovered. The 2 databases that I have a problem with have also been recovered. However, for them, the status recovering is shown permanently.
>

I'm flying blind here, but this could be a transaction log problem. run the stored procedure sp_dboption {database name} to see what your options are set for those two databases. It might be that you need to expand the transaction log. I'm having a hard time visualizing what SQL Enterprise Manager options to use to do this because I don't have access to it from my workstation today.

>>To get more info if this occurs in the future, set the "recovery flags" parameter via sp_configure to 1, from the default 0.
>
>Where do I go to set this? Can I do that if my database have the recovering flag permanent?

From ISQL, you can USE {database name} (just like VFP) and then EXEC sp_configure or EXEC sp_dboption.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform