|
dbunload -c "DBF=E:\SAP\MobilePlatform3\MR30\Servers\Unwire dServer\data\clusterdb;UID=dba;PWD=sql" -ar SQL Anywhere Unload Utility Version 16.0.0.2038 Connecting and initializing * SQL error: Unable to start database server i have tried running the cmd as administrator and granted access to 'everyone' on E drive. Thank you, Babji |
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.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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:
question asked: 22 Dec '16, 20:27
question was seen: 2,141 times
last updated: 29 Dec '16, 11:30
It is likely that the dbunload command cannot locate the standalone database engine executable (dbeng16.exe). You can add START connection parameter to locate the engine or if SMP does not ship that engine, force it to use the network server.
START=<full_path_and_executable>
i.e.,
-or-
In addition to Chris' comment, I would verify that the file E:\SAP\MobilePlatform3\MR30\Servers\Unwire dServer\data\clusterdb.db (note the <dot>db at the end) exists and that you have permission to the file. I also noticed that there is a space between "Unwire" and "dServer" - is that meant to be there? ... or is that just a typo? Verify that you are using the correct full pathname to the database file.
Thank you so much Chris,The thing is i have deleted the log file of domainlogdb database and want to build a new database in its place and i am using the following command which is failing i am sure its due to missing file but how do i create a new database in place of the old one without the old databases transaction log file.
dbunload -c "DBF=E:\SAP\MobilePlatform3\MR30\Servers\U dServer\data\domainlogdb;UID=DBA;PWD=sql;START=C:\Windows\System32\dbsrv16. -an domainlog.db SQL Anywhere Unload Utility Version 16.0.0.2038 Connecting and initializing * SQL error: Unable to start specified database: server exit code 309
Thank you very much Mark.
Thank you so much Chris,The thing is i have deleted the log file of domainlogdb database and want to build a new database in its place and i am using the following command which is failing i am sure its due to missing file but how do i create a new database in place of the old one without the old databases transaction log file.
dbunload -c "DBF=E:\SAP\MobilePlatform3\MR30\Servers\U dServer\data\domainlogdb;UID=DBA;PWD=sql;START=C:\Windows\System32\dbsrv16. -an domainlog.db SQL Anywhere Unload Utility Version 16.0.0.2038 Connecting and initializing * SQL error: Unable to start specified database: server exit code 309
Hi Chris,
Finally i was able to create a new database and also use the dbunload utility from cmd prompt but now my problem is i have to shrink the databases at regular intervals and with the dbunload on Windows machine its only allowing -an option which is shrink the old db and create new database files in a new location and then i have to stop the SMP/SUP services and copy these new files to actual data folder,Could you please help with a script to shrink the databases on regular intervals without the need to create and copy new files and stopping the services.
Thank you, Babji
Why are you needing to "shrink the database"? The space in the database file will get reused if you are deleting data from the database. In fact, it could be argued that you should grow your database and then defragment the dbspace(s) so you get optimal read/write performance.