How to stop and start the Sybase service - Revision history

Russ horton at 00:03, 7 September 2012

2012-09-07T00:03:21Z

← Older revision		Revision as of 00:03, 7 September 2012
Line 59:		Line 59:

	=Restarting just one database=		=Restarting just one database=
	It is possible to restart a single database without restarting your database server as shown above. This is valuable if you're running multiple databases on the same database server such as multiple companies or a production and test database.		It is possible to restart a single database without restarting your database server as shown above. This is valuable (and only possible) if you're running multiple databases on the same database server such as multiple companies or a production and test database.

	You'll need to run the Sybase utility DBISQLC.exe, connect to your ~~database~~, and then run the following commands:		You'll need to run the Sybase utility DBISQLC.exe, connect to one of your databases that you're not restarting, and then run the following commands:

	<source lang="SQL">		<source lang="SQL">

Russ horton: /* Restarting a particular database */

2012-09-06T22:55:59Z

Restarting a particular database

← Older revision		Revision as of 22:55, 6 September 2012
Line 58:		Line 58:
	<br style="clear: both" />		<br style="clear: both" />

	=Restarting ~~a particular~~ database=		=Restarting just one database=
	It is possible to restart a single database without restarting your database server as shown above. This is valuable if you're running multiple databases on the same database server such as multiple companies or a production and test database.		It is possible to restart a single database without restarting your database server as shown above. This is valuable if you're running multiple databases on the same database server such as multiple companies or a production and test database.

Line 65:		Line 65:
	<source lang="SQL">		<source lang="SQL">
	STOP DATABASE 'TestCompany';		STOP DATABASE 'TestCompany';

	START DATABASE 'TestCompany';		START DATABASE 'TestCompany';
	</source>		</source>

			In the above statements, "TestCompany" represents the name of the database you wish to restart. TestCompany also happens to be the default name given to a test database by our installer when performing a test environment install.

Russ horton at 22:54, 6 September 2012

2012-09-06T22:54:05Z

← Older revision		Revision as of 22:54, 6 September 2012
Line 57:		Line 57:

	<br style="clear: both" />		<br style="clear: both" />

			=Restarting a particular database=
			It is possible to restart a single database without restarting your database server as shown above. This is valuable if you're running multiple databases on the same database server such as multiple companies or a production and test database.

			You'll need to run the Sybase utility DBISQLC.exe, connect to your database, and then run the following commands:

			<source lang="SQL">
			STOP DATABASE 'TestCompany';
			START DATABASE 'TestCompany';
			</source>

Luke steinmetzer at 19:51, 15 August 2012

2012-08-15T19:51:35Z

← Older revision		Revision as of 19:51, 15 August 2012
Line 32:		Line 32:

	==CMS 7.0 or earlier==		==CMS 7.0 or earlier==
	=== How to Stop the Sybase service ===		=== How to Stop the Sybase service if running CMS 7.0 or earlier ===


Line 39:		Line 39:
	<br style="clear: both" />		<br style="clear: both" />

	=== How to Start the Sybase service ===		=== How to Start the Sybase service if running CMS 7.0 or earlier ===

	[[image:Service72.png]]		[[image:Service72.png]]
Line 47:		Line 47:

	==CMS 8.0 or later==		==CMS 8.0 or later==
	=== How to Stop the Sybase service ===		=== How to Stop the Sybase service if running CMS 8.0 or later ===

	[[image:Service81.png]]		[[image:Service81.png]]

	=== How to Start the Sybase service ===		=== How to Start the Sybase service if running CMS 8.0 or later ===

	[[image:Service82.png]]		[[image:Service82.png]]

Luke steinmetzer: Created page with '=Overview= This article details the instructions for stopping the Sybase service. PLEASE NOTE: The Sybase service is responsible for allowing CMS communication to a variety of s…'

2012-05-22T00:12:55Z

Created page with '=Overview= This article details the instructions for stopping the Sybase service. PLEASE NOTE: The Sybase service is responsible for allowing CMS communication to a variety of s…'

New page

=Overview=

This article details the instructions for stopping the Sybase service. PLEASE NOTE: The Sybase service is responsible for allowing CMS communication to a variety of systems, That said other programs or systems may ALSO require this service. you should only ever follow the instructions below at the request of CMS support or because another one of our Wiki articles has referred you to here.

==WARNING==

CRITICAL: PLEASE ENSURE NO ONE IS LOGGED INTO CMS BEFORE YOU STOP THIS SERVICE. STOPPING THE SYBASE SERVICE WILL SEVER ALL CMS CONNECTIONS AND CAN LEAD TO UNFORESEEN ISSUES IF YOU HAVE AGENTS STILL LOGGED INTO CMS.
*You can try deleting the file CMSNET.dat from the \NewHaven Software directory and, if successful, you can be sure nobody is logged into CMS. This file will be recreated the next time someone logs into CMS so there is no harm in deleting.
*Using the Manage Open Files section in Windows is another good method of determining if anyone has any related files/programs open (you'd be looking for open files in \NewHaven Software) and can also use this section to disconnect those users if needed.

= How to open the Services menu =

Below are instructions on how to access your Services menu in Windows. Please note there are a number of different ways to access this menu depending on what version of Windows you are running. The screen shots and steps outlined below are for Windows Server 2008, that said this method should work for all versions of Windows we currently support running CMS on.

[[image:Services1.png]]

[[image:Services2.png]]

[[image:Services3.png]]

[[image:Services4.png]]

<br style="clear: both" />

= Determine what version of Sybase you are running =

The instructions below can vary a little depending on what version of Sybase you are running. Your Sybase version is dependent on what version of CMS you are running.

*CMS 7 or earlier runs Sybase version 9. Please follow the instructions below for CMS version 7 or below.
*CMS version 8 or later runs Sybase version 12. Please follow the instructions below for CMS version 8 or above.

==CMS 7.0 or earlier==
=== How to Stop the Sybase service ===

[[image:Service71.png]]

<br style="clear: both" />

=== How to Start the Sybase service ===

[[image:Service72.png]]

<br style="clear: both" />

==CMS 8.0 or later==
=== How to Stop the Sybase service ===

[[image:Service81.png]]

=== How to Start the Sybase service ===

[[image:Service82.png]]

<br style="clear: both" />