------=_NextPart_000_0054_01BEDFF4.E95DB780
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
We are new to SQL, and wasn't sure about the size the emerald DB and the =
transaction logs should be? We have the database size for Emerald set =
for 877 meg, and are using 817 of it. Our transaction log is 2 gig with =
6 assigned to it. Is this about right for a database with about 4000 =
users? How can we decrease the size of the current transaction log =
(truncate? we just backed up the emerald db and everything i've seen =
says truncation will clear out everything before the backup) , and =
what's a "safe" size to set the log for.=20
TIA
-------------------------------------------------------------------------=
---------------------------------------------
Andrew Stinson Apex 2000 Internet Services =
Corporation =20
mailto:astinson@apex2000.net http://www.apex2000.net (915) 570-1676
-------------------------------------------------------------------------=
---------------------------------------------
------=_NextPart_000_0054_01BEDFF4.E95DB780
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">