I'm setting up backup of a SA 12 64-bit server.

Where is the configuration, as entered in Service Properties in Sybase Central, stored ?

I have the datbase files, but for a quick restore I also need to restore each database service running on the server.

asked 28 May '13, 03:27

OskarEmil's gravatar image

OskarEmil
431141831
accept rate: 50%

edited 28 May '13, 03:49

Volker%20Barth's gravatar image

Volker Barth
30.0k295449654


AFAIK, you can use the DBSVC utility to both create services and show their definitions and creation parameters.

On Windows, you can use the following command to list the creation commands of all SA services:

%SQLANY12%\bin64\dbsvc -cm -l

The following will list the creation commands of a particular sercive:

%SQLANY12%\bin64\dbsvc -cm -g MySaService

If you add "-o MyLog.txt", the output is written to a file, and you should easily be able to use these commands to create the services at another box.


Note: I haven't checked whether services created by Sybase Central are listed by dbsvc - but I would think so. And for reproducable results/configurations, I would generally recommend command line tools over GUI-based ones...

permanent link

answered 28 May '13, 03:43

Volker%20Barth's gravatar image

Volker Barth
30.0k295449654
accept rate: 32%

edited 28 May '13, 03:48

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:

×409
×101
×72
×34
×8

question asked: 28 May '13, 03:27

question was seen: 802 times

last updated: 28 May '13, 03:49