This Message was undeliverable due to the following reason:
The following destination addresses were unknown (please check
the addresses and re-mail the message):
SMTP <macmilan@yebo.co.za>
Please reply to Postmaster@neptune.yebo.co.za
if you feel this message to be in error.
--===========================_ _= 7560424(15775)
Content-Type: message/rfc822
Received: from relay01.iafrica.com ([196.7.0.160]) by neptune.yebo.co.za
(Post.Office MTA Undefined release Undefined
ID# 0-54426U40000L40000S0V35) with ESMTP id AAA8552
for <macmilan@yebo.co.za> Fri, 16 Oct 1998 05:09:09 +0200
Received: from [207.53.165.8] (helo=walnut.iea-software.com)
by relay01.iafrica.com with esmtp (Exim 1.92 #2)
for macmilan@sprintlink.co.za
id 0zU0Fi-0007by-00; Fri, 16 Oct 1998 05:08:32 +0200
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za002452 for <emerald@iea-software.com> Thu, 15 Oct 1998 19:58:28 -0700
Received: from [203.162.3.234] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id bbmbaaaa for <emerald@iea-software.com> Thu, 15 Oct 1998 19:58:23 -0700
Received: from mail.vnn.vn by hanoi-fw-ex.vnn.vn
via smtpd (for external.iea-software.com [207.53.165.3]) with SMTP; 16 Oct 1998 03:04:31 UT
Received: from newsrv.cmchanoi.cmc.com ([202.167.114.207]) by mail.vnn.vn
(Netscape Mail Server v2.02) with ESMTP id AAH21812
for <emerald@iea-software.com> Fri, 16 Oct 1998 10:04:26 +0700
Received: from mdaemon.cmc.com.vn (localhost [127.0.0.1]) by newsrv.cmchanoi.cmc.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.1960.3)
id VAX1GPLG; Fri, 16 Oct 1998 22:01:21 +0700
Received: from MDaemon Pop Client [203.162.0.24] by mdaemon.cmc.com.vn [127.0.0.1] with POP (MDaemon.v2.7.SP3.T) for <emerald@iea-software.com> Fri, 16 Oct 1998 21:01:55 +0700
Received: from hanoi-fw.vnn.vn [203.162.0.100] by mr-hn.vnn.vn [203.162.0.24] with SMTP (MDaemon.v2.7.SP3.R) for <DTHue@hn.cmc.com.vn> Fri, 16 Oct 1998 08:23:48 +0700
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za002409 for <emerald@iea-software.com> Thu, 15 Oct 1998 14:04:27 -0700
Received: from [207.53.165.21] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id eplbaaaa for <emerald@iea-software.com> Thu, 15 Oct 1998 14:04:22 -0700
Message-ID: <3626666C.EDA1D903@iea-software.com>
Date: Thu, 15 Oct 1998 14:17:32 -0700
From: "Dale E. Reed Jr." <daler@iea-software.com>
Organization: IEA Software, Inc.
X-Mailer: Mozilla 4.06 [en] (WinNT; I)
MIME-Version: 1.0
To: John Lange <radadmin@palacenet.net>
CC: emerald@iea-software.com
Subject: Re: SQL - Increase Log Size
References: <3.0.3.32.19981015151221.00fb2930@palacenet.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Script: \\FilterScript.mml
X-DomainScript: palacenet.net\\script.mml
X-UserScript: iea-software.com\emerald\script.mml
X-MDaemon-Deliver-To: emerald@iea-software.com
John Lange wrote:
>
> HI
>
> I want to increase the size of my log device, but have more than 4GB Free
> on the servers hard drive. So in EM the sizes show up in -negative numbers.
>
> What is the EXACT syntax for an SQL command to increase the Log Device
> Size? I should still be able to expand the db with EM.
Its DISK RESIZE. This is from the tsql docs:
Allows you to expand a device. You can use DISK RESIZE on any database
device, including the MASTER device.
Syntax
DISK RESIZE
NAME = logical_device_name,
SIZE = final_size
where
logical_device_name
Specifies the database device to resize.
final_size
Is the final size to which the device should be expanded, specified in
2K pages.
Remarks
The DISK RESIZE statement expands a device; it does not shrink devices
or alter any databases that reside on that device. DISK RESIZE cannot be
used for dump devices or the TEMPDB device when tempdb is in RAM.
Examples
A. Increase the Size of a Device
This example increases the size of DEVICE1 from it's initial size of 12
MB to 20 MB.
DISK RESIZE
NAME = 'DEVICE1',
SIZE = 10240
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
--===========================_ _= 7560424(15775)--