Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database in recovering mode
Message
De
14/12/1998 09:47:36
 
 
À
09/12/1998 16:02:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00165703
Message ID:
00167160
Vues:
28
>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.

The stored procedure can't be executed if the database is in recovering mode.

>From ISQL, you can USE {database name} (just like VFP) and then EXEC sp_configure or EXEC sp_dboption.

It's the same thing here.

To extand the log, we have to go in the Manage menu and select Databases. From there, clicking on the database brings the form to do that. However, the form can't be accessed if the database is in recovering mode.

I tried to delete the database and can't do it as well as the database is in recovering mode.

Now, I don't want to create 2 other databases on different names as I'll have to change several things on our project.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform