Solved

How to properly shutdown ASE Server

Posted on 2002-07-22
3
1,149 Views
Last Modified: 2010-08-05
Hello,
I have two questions:

1.
  I am running ASE 12 on WINNT.
Is there a proper way to shutdown the server?
What do I need to do to properly stop the server
before shutdown/restart the computer so that ASE won't
try to "recover" when the computer is back online.

2.  Is there a way you can set the server so that it would automatically purge/clean up the log files?
The way I do it now is once in a while I have to issue
the dump trans/database <dbname> with no_log.  

Regards.
0
Comment
Question by:johnchan2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Accepted Solution

by:
ajith_29 earned 100 total points
ID: 7193253
1)Throught the isql prompt to shutdown the server will be

checkpoint
go
shutdown with wait
go


2)The command for having your logs purged is  
use master
go
sp_dboption database ,'trunc log on chkpt'
go

0
 
LVL 1

Expert Comment

by:bkumar
ID: 7414270
1. Make the services Automatic for the ASE Server and Backup Server.

2. For All the databases you run this seprately from the isql prompt:

use master
go
sp_dboption <database name>,'trunc log on chkpt'
go



0
 
LVL 1

Author Comment

by:johnchan2000
ID: 7416637
ajith_29,
Sorry for the delay.  I lost track of the question.

bkumar  -- your answer should also be accepted.

Thanks
johnchan2000
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question