Solved

How to properly shutdown ASE Server

Posted on 2002-07-22
3
1,139 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
Comment Utility
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
Comment Utility
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
Comment Utility
ajith_29,
Sorry for the delay.  I lost track of the question.

bkumar  -- your answer should also be accepted.

Thanks
johnchan2000
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
finding which fields are "nullable" 4 688
Pivot and Unpivot in Sybase 2 1,524
SyBase SQL Query 7 143
SQL Query  Syntax 3 84
HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now