Truncating SQL Transaction Log

[Guest]

Problem - SQL transaction log is defined at 19GB of total defined space.
Actual size of log is 2.2gb.

There was a discussion a while back of how to truncate an SQL transaction
log and to also reduce the defined size of the log. Can someone please
remind me on the solution to this problem?

Thanks,

Crawford Winter
Technical Analyst
Transamerica Life Canada

 

[WalterD]

RE: Truncating SQL Transaction Log STEPS

stop oneworld service

backup the entire database (safety)

detach the database;

i.e sp_detach_db JDEPROD

Rename the log file;

i.e JDEPRODLOG.ldf to JDEPRODLOG.bak

Attach the database file;

i.e sp_attach_db @dbname = N'JDEPROD',
@filename1 = N'd:\sqldevices\mjc98data.mdf'

SQL will recreate the file.

Erase the *.bak file.


You should run SQL mainatainace weekly, helps performance and on disk space.







Walter De Melo
Mosaic Group Inc.

 

[rafaelrv]

First of all, which version of SQL are you using.
If your version is SQL 6.5 or 7.0 (Microsoft), in the porperties of Bata
Base you have the option to check Truncate Transaction Log in check point,
this property allows you in a certain time to truncate the history of
Transaction. I only propouse you if you don't have enough disk space,
because in a critic situation this can be helpfull.

Cheers,

Rafael R. V.
I.T. Manager

----- Original Message -----
From: Crawford Winter <[email protected]>
To: <[email protected]>
Sent: Tuesday, January 30, 2001 3:47 PM
Subject: Truncating SQL Transaction Log ~~0:4791


> Problem - SQL transaction log is defined at 19GB of total defined space.
> Actual size of log is 2.2gb.
>
> There was a discussion a while back of how to truncate an SQL transaction
> log and to also reduce the defined size of the log. Can someone please
> remind me on the solution to this problem?
>
> Thanks,
>
> Crawford Winter
> Technical Analyst
> Transamerica Life Canada
>
>
>
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
4791
> *************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************