Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.2k361550822


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.3k41564
accept rate: 19%

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,051 times

last updated: 04 Feb '14, 09:42