• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL Server 7.0 - shrink transaction log

DeRay_Scholz

Active Member
This is to all the SQL Server gurus out there.

We have a database (Sql Server 7.0) that is taking up 11 gigs of free space with the transaction log. I have truncated the log, set the option to truncate log on checkpoint, ran a sql server backup of the database, stopped and restarted sql server.

The log has shrunk to 36 MB of used space but still has 11 gigs of free space. What do I need to do to free up this space?

Thanks,
DeRay Scholz
The Upper Deck Company
B733.2 SP11.2 NT / SQL Server 7.0
 

b_gilmore

Well Known Member
Re: [SQL Server 7.0 - shrink transaction log ]

DBCC Shrinkdatabase or
DBCC Shrinkfile

Either one will do the trick.


DeRay_Scholz <deray_scholz@upperdeck.com> wrote:
> This is to all the SQL Server gurus out there.
>
> We have a database (Sql Server 7.0) that is taking up 11 gigs of free space
with the transaction log. I have truncated the log, set the option to truncate
log on checkpoint, ran a sql server backup of the database, stopped and
restarted sql server.
>
> The log has shrunk to 36 MB of used space but still has 11 gigs of free
space. What do I need to do to free up this space?
>
> Thanks,
> DeRay Scholz
> The Upper Deck Company
> B733.2 SP11.2 NT / SQL Server 7.0
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=3069

> *************************************************************
> 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
> *************************************************************


____________________________________________________________________
Get free email and a permanent address at http://www.amexmail.com/?A=1
 

Ricardo Paz

Reputable Poster
Try to shrink the log (not only truncate).

However be sure to have an updated backup of your data just in case.

OW 73.3.2 SP 10.1 / NT 4.0 / SQL 7.0

Greetings.
SI. Ricardo Paz Castañón
Systems Chief
Comercial de Herramientas S.a de C.v.
+52(8)369-35-35
rpaz@cohesa.com.mx
www.cohesa.com


-----Mensaje original-----
De: DeRay_Scholz [mailto:deray_scholz@upperdeck.com]
Enviado el: Jueves, 21 de Diciembre de 2000 02:23 p.m.
Para: jdelistml@jdelist.com
Asunto: SQL Server 7.0 - shrink transaction log ~~0:3069


This is to all the SQL Server gurus out there.

We have a database (Sql Server 7.0) that is taking up 11 gigs of free space
with the transaction log. I have truncated the log, set the option to
truncate log on checkpoint, ran a sql server backup of the database, stopped
and restarted sql server.

The log has shrunk to 36 MB of used space but still has 11 gigs of free
space. What do I need to do to free up this space?

Thanks,
DeRay Scholz
The Upper Deck Company
B733.2 SP11.2 NT / SQL Server 7.0


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=3
069
*************************************************************
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
*************************************************************



Lic. Ricardo Paz Castanon
Jefe Sistemas COHESA
 

misenberg

Member
DeRay,

Here is the syntax to clean up the log Dump transaction DATABASENAME
with no_log. You may need to reboot your system.

Respectfully Yours,
Michael Isenberg
Systems Engineer, DBA and CNC
Oresis Communications, Inc.
503-466-6266 DD
503-969-1975 Cell
503-629-8009 FAX
e-mail misenberg@oresis.com
 
Top