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. asked 03 Feb '14, 23:16 VMeng Volker Barth |
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. answered 03 Feb '14, 23:34 Erik Anderson Thanks, Erik. That makes sense.
(03 Feb '14, 23:42)
VMeng
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).
(04 Feb '14, 07:49)
Volker Barth
|
To pass options to the server that you are starting, use the DatabaseSwitches (DBS) connection parameter. answered 04 Feb '14, 09:42 JBSchueler |