Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database in recovering mode
Message
De
09/12/1998 16:02:34
 
 
À
09/12/1998 15:50:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00165703
Message ID:
00165780
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform