Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database in recovering mode
Message
From
14/12/1998 09:47:36
 
 
To
09/12/1998 16:02:34
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00165703
Message ID:
00167160
Views:
23
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform