The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
29.3k287438644


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
1.9k2836
accept rate: 16%

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:

×30
×22

question asked: 03 Feb '14, 23:16

question was seen: 505 times

last updated: 04 Feb '14, 09:42