cancel
Showing results for 
Search instead for 
Did you mean: 

How to specify -f option in SAConnection

0 Kudos
2,267

When using dbeng12.exe, we can specify -f option to force dababase to start without transaction log; when using .net SAConnection, what is the parameter in the connection string that is corresponding to -f ?

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member

You realize that the -f option will not launch any listeners and you cannot build a database connection to an engine launched with -f, right? It will start, load the database, do what it can, then shut down again.

0 Kudos

Thanks, Erik. That makes sense.

VolkerBarth
Contributor
0 Kudos

FWIW, the same is true for the other recovery options, i.e. those that include applying the transaction log(s) and then shutting down the database (-a, -ad, -ar), though the behaviour of -ad and -ar can be enhanced with option -as to keep the database running after the successful application of the transaction log(s).

jack_schueler
Product and Topic Expert
Product and Topic Expert
0 Kudos

To pass options to the server that you are starting, use the DatabaseSwitches (DBS) connection parameter.