dbTalk Databases Forums  

Re: Database log-file is grown

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools Re: Database log-file is grown

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Re: Database log-file is grown in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Carlos Eduardo Rojas
 
Posts: n/a

Default Re: Database log-file is grown - 07-01-2003 , 11:10 AM





You can also read about recovery modes in books online. Maybe you can just
use simple, if you don't need to take backups of your transaction logs.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example


"Karl Reinl" <karl.reinl (AT) isc-ub (DOT) de> wrote

Quote:
Hallo,

I am using SQLServer2000 and now I found that the Database log-file is
grown
too big
Database has 33 MB the log-file 10 GB.

All I tryed to reduce, was without success ( sometimes was cutting 400
KB )

Is there no way like in SQL7 to cut it down ?
Mit freundlichen Grüßen
Karl Reinl

karl.reinl (AT) isc-ub (DOT) de

ISC it & software consultants GmbH
Sportplatzstraße 30
90765 Fürth
Tel 0049 911 936 75 76
Fax 0049 911 936 75 86
www.isc-ub.de



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top