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.
--===========================_ _= 5389404(23070)
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 AAA31545
for <macmilan@yebo.co.za> Thu, 15 Oct 1998 23:17:32 +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 0zTulN-0006a8-00; Thu, 15 Oct 1998 23:16:55 +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 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
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--===========================_ _= 5389404(23070)--