DB Transactional Log Files

I have SQL Server 2000 Enterprise with SP3A and Windows
2000 Advanced Server.
I have one database with two transactional log files. The
two transactional log files are on different drives
(F:,G.
I would like to have the first transaction log file (F
set to automatically grow and the second transaction log
file restricted log growth to 30GB.
Please help me with this issue.
Thanks,
Dan
Within Enterprise Manager (within the SQL Server program group) you =
should be able to=20
right click on the database icon
properties
transaction log tab
Configure one file to be restricted to a maximum file size and the other =
file would be unrestricted. =20
With that said, 30GB is a fairly large transaction log file. If you =
need more than this you are probably doing massive amounts of data =
movement (into a reporting database, perhaps) OR you are not backing up =
your data in the best manner. If you want to investigate backup =
techniques, Books Online (within the SQL Server program group) has lots =
of information regarding backup and restore as well as performing =
transaction log backups and having the ability to restore to the point =
of failure (should one occur).
--=20
Keith
"Dan" <anonymous@.discussions.microsoft.com> wrote in message =
news:1e1ea01c4554f$266f1d10$a301280a@.phx.gbl...
>=20
> I have SQL Server 2000 Enterprise with SP3A and Windows=20
> 2000 Advanced Server.
>=20
> I have one database with two transactional log files. The=20
> two transactional log files are on different drives=20
> (F:,G.=20
>=20
> I would like to have the first transaction log file (F=20
> set to automatically grow and the second transaction log=20
> file restricted log growth to 30GB.
>=20
> Please help me with this issue.
>=20
> Thanks,
>=20
> Dan