cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Is it possible to start a database read-only when it needs recovery?

MCMartin
Participant
1,011

Is it possible to start a database read-only when it needs recovery?

I have a DB which stopped with "max file size reached", so DB says it needs recovery when I try to start it. So my wish would be to start the DB read-only to do an unload. Any advice?

View Entire Topic
0 Kudos

Well, in generally in RDBMS it is generally not possible to start a database in a read only mode when it needs recovery. Whenever database required recovery it means that there is the problem with the consistancy of database which you can further perform by taking appropriate steps that you can find over Google. Thanks