TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
Hi,
I use the following commands when using MSDE database, I really don�t know
if it could be used on SQL Databases.
Determining Size Limit of Enterprise DB
?Use osql command interpreter from command prompt
?Found in one of the following locations:
?\Program Files\Microsoft SQL Server\80\Tools\Binn for MSDE/SQL 2000
?\MSSQL7\Binn for MSDE/SQL 7
?Start up osql:
?osql -E (logs into MSDE via NT trusted authentication)
?osql -U <username> (where <username> is a valid SQL user)
Commands Used to Determine DB Size
?To get maximum size of database plus other statistics about ISSDATA and
ISSLOG, type from command prompt after starting osql:
?use ISSED
?go
?sp_helpfile
?go
Changing Size Limit of Enterprise DB
?To increase size limit of Enterprise DB, use the following osql command
from command prompt after starting osql:
?alter database ISSED modify file (name=ISSDATA, maxsize=<new size>MB/GB)
?go
Determining if Enterprise DB is Full
?Can't tell from size of DB files
?Figure out using osql commands
?Start osql
?Type the following:
?use ISSED
?go
?sp_spaceused
?go
?
Deleting Event Data from Enterprise DB
?For small range of events:
?Navigate to ViewOptionsEnterprise Database Maintain, choose a date
range, and click Clear Date Range
?For large number of events to be deleted:
?Stop ALL Event Collectors. (Note: If you do not stop all Event
Collectors first, you could corrupt your database and require a complete
reinstall!)
?Start osql and type use ISSED, iss_truncateevents, go.
====================================
Mauricio F. Mu�oz Quevedo
Project Engineer
Etek International Holding Corp- Colombia
ISO 9001 certified
Tel: +57-( 1)-257-1520
Fax: +57-(1)-257-6960
www.etek.com.co
Este correo y cualquier archivo anexo son confidenciales y para uso
exclusivo de la persona o entidad de destino. Esta comunicaci�n puede
contener informaci�n protegida por el privilegio de cliente-abogado. Si
usted ha recibido este correo por error, equivocacion u omisi�n queda
estrictamente prohibido la utilizaci�n, copia, reimpresi�n, reenvio o
cualquier acci�n tomada sobre este email y puede ser penalizada legalmente.
En tal caso, favor notificar en forma inmediata al remitente.
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message. Any
unauthorized review, use, disclosure, dissemination, forwarding, printing
or copying of this email or any action taken in reliance on this e-mail is
strictly prohibited and may be unlawful.
==============================================
[EMAIL PROTECTED]
cglobal.com To: <[EMAIL PROTECTED]>
Sent by: cc: [EMAIL PROTECTED]
[EMAIL PROTECTED] Subject: Re: MS SQL - Problem
et
17/07/2002 04:52
a.m.
TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any
problems!
----------------------------------------------------------------------------
Yo
I had the exact same problem yesterday, as I tried to delete 1.6GByte of
events out of the ISSED database.
Using the 'maintain' GUI from the RS Console, it takes about one hour to do
so...
ISS: Isn't there a kind of 'purge' function or so to do so?!? I find the RS
Console SQL database handling capabilities extremely rudimentary.... not
all RS users are SQL gurus you know...
Regards
Andres
"Eng. Ahed M.
Okasha" To:
<[EMAIL PROTECTED] cc:
v.edu.kw> Subject: MS SQL - Problem
Sent by:
owner-issforum@i
ss.net
16.07.2002 07:17
TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any
problems!
----------------------------------------------------------------------------
Hi again,
My other problem is regarding the Database,
I'm using MS SQL 2000 as my Database for
RS 6.5 console, and I have 3 NS active and
Sending data to it.
My question is how to delete the records in
The database after backing it up? (Not using
The RS Console Configuration -> Enterprise Database
Configuration) I want it using SQL commands or
A 3rd party software.
Thanks,
Eng. Ahed M. Okasha
IT Security
_________________________________________________________________
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
