SQL Anywhere 11.0.1 EBF 2527

We are running several databases within the one SQL Anywhere Server instance (running as a windows service).

Is there anyway we can remove one of the databases from the server instance without stopping the server instance?

Additionally, is there anyway we can add a database from the server instance without stopping the server instance?

asked 16 May '11, 23:10

Nick%20Brooks's gravatar image

Nick Brooks
528182032
accept rate: 50%


see the STOP DATABASE statement and START DATABASE statement.

permanent link

answered 17 May '11, 02:54

Martin's gravatar image

Martin
8.6k119151237
accept rate: 14%

Oh, I even wasn't aware that there's another SQL Anywhere online doc site besides the (more interactive) DocCommentXchange...

(17 May '11, 04:10) Volker Barth
Replies hidden

@Martin - Thanks for that. START, STOP - The only two words I didn't search for in the documentation... sigh.

(17 May '11, 05:50) Nick Brooks

And I can never remember der DocCommentXchange website, I really have to bookmark it ;-)

(17 May '11, 08:17) Martin
1

I usually use the link at the bottom of the local help files:

DCX

(17 May '11, 08:38) Volker Barth

Additionally, (for completeness) you can automatically start a database on a running server as part of connecting by specifying ServerName and CommLinks as well as DatabaseFile (DBF - the path to the database filename), optionally DatabaseName (DBN), UID and PWD for the database being started. Once there are no connections to this database it will automatically stop unless you specify AutoStop=No on the connection that starts the database.

Note that this is only recommended for personal servers. For network servers you would need to use -gd all to automatically a start database, which is not recommended.

permanent link

answered 17 May '11, 09:30

Ian%20McHardy's gravatar image

Ian McHardy
3.1k23354
accept rate: 38%

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:

×36
×12

question asked: 16 May '11, 23:10

question was seen: 2,152 times

last updated: 17 May '11, 09:30