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's gravatar image

VMeng
1567714
accept rate: 0%

edited 04 Feb '14, 03:39

Volker%20Barth's gravatar image

Volker Barth
31.3k312458674


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.

permanent link

answered 03 Feb '14, 23:34

Erik%20Anderson's gravatar image

Erik Anderson
42181223
accept rate: 15%

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.

permanent link

answered 04 Feb '14, 09:42

JBSchueler's gravatar image

JBSchueler
2.1k2837
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×35
×23

question asked: 03 Feb '14, 23:16

question was seen: 639 times

last updated: 04 Feb '14, 09:42