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? |
see the STOP DATABASE statement and START DATABASE statement. 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
|
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. |