Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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
1708815
accept rate: 0%

edited 04 Feb '14, 03:39

Volker%20Barth's gravatar image

Volker Barth
40.5k365556827


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
43681323
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
3.3k41665
accept rate: 20%

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:

×44
×29

question asked: 03 Feb '14, 23:16

question was seen: 2,135 times

last updated: 04 Feb '14, 09:42