A message that you sent could not be delivered to all of its recipients. The
following address(es) failed:
annabel@pop3.zamnet.zm:
Too many "Received" headers for remote delivery
------ This is a copy of the message, including all the headers. ------
Return-path: <emerald-return@iea-software.com>
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SX-0006GE-00; Fri, 16 Oct 1998 05:21:45 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SW-0006GC-00; Fri, 16 Oct 1998 05:21:44 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SW-0006GA-00; Fri, 16 Oct 1998 05:21:44 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SV-0006G8-00; Fri, 16 Oct 1998 05:21:43 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SV-0006G6-00; Fri, 16 Oct 1998 05:21:43 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SU-0006G4-00; Fri, 16 Oct 1998 05:21:42 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SU-0006G2-00; Fri, 16 Oct 1998 05:21:42 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0ST-0006G0-00; Fri, 16 Oct 1998 05:21:41 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0ST-0006Fy-00; Fri, 16 Oct 1998 05:21:41 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SS-0006Fw-00; Fri, 16 Oct 1998 05:21:40 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SS-0006Fu-00; Fri, 16 Oct 1998 05:21:40 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SS-0006Fs-00; Fri, 16 Oct 1998 05:21:40 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SR-0006Fp-00; Fri, 16 Oct 1998 05:21:39 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SR-0006Fn-00; Fri, 16 Oct 1998 05:21:39 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SQ-0006Fl-00; Fri, 16 Oct 1998 05:21:38 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SQ-0006Fj-00; Fri, 16 Oct 1998 05:21:38 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SP-0006Fh-00; Fri, 16 Oct 1998 05:21:37 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SP-0006Ff-00; Fri, 16 Oct 1998 05:21:37 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SO-0006Fd-00; Fri, 16 Oct 1998 05:21:36 +0200
Received: from puku.zamnet.zm [196.7.240.1]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SO-0006Fb-00; Fri, 16 Oct 1998 05:21:36 +0200
Received: from relay.zamnet.zm [196.7.240.3]
by puku.zamnet.zm with smtp (Exim 1.61 #1)
id 0zU0SO-0006FZ-00; Fri, 16 Oct 1998 05:21:36 +0200
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8])
by relay.zamnet.zm (8.9.1a/8.9.1a) with ESMTP id FAA13450
for <amwansa@zamnet.zm> Fri, 16 Oct 1998 05:20:14 +0200 (ZMT)
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
X-ListMember: amwansa@zamnet.zm [emerald@iea-software.com]
Content-Transfer-Encoding: 7bit
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