Solved

How to properly shutdown ASE Server

Posted on 2002-07-22
3
1,141 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
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Knowing where your website is hosted is as important as the features you receive, the monthly fee, and the support you receive. Due diligence should be done when choosing your next hosting provider.
Google always has something new and amazing up its sleeve, and the most current thing that they have been working on is another step in the evolution of Google Search, from machine learning to its brilliant successor, deep learning.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

778 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