Re: Log file is increeasing too much

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter Yeoh (nospam_at_nospam.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 14:24:30 +0800

If you are using the FULL recovery model, you would need to backup the log
before it can be reused. Otherwise, you might consider using the simple
recovery model.

Another possibility is that your import process is done within one
transaction, hence all the data is either committed or rolled back. If this
was the case (and you are using the simple recovery model), you might
consider breaking the import into smaller transactions.

If you are deleting everything initially, you might also consider using the
TRUNCATE TABLE option as the row deletion is not individually logged. 

-- 
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files?  Use MiniSQLBackup Lite, free!
"Psycho" <Psycho@discussions.microsoft.com> wrote in message
news:26E3911D-CEA7-4389-8E26-1E76B3EEDF11@microsoft.com...
> Hi
> i have a database and a proccess which delete everything from database and
> then import some stuff from other databases.
> how can i reduce to increase log file because sometimes import stops
because
> of it.
> I use the following procedures :
>
> backup log mydatabase with truncate_only
> dbcc shrinkdatabase (mydatabase)
>
> i was wondering if it's any possible way to put a maximum size for log
file
> and when it get to the maximum file size to override the existent logs and
> not raise me the error that "The log file for database 'mydatabase' is
full.
> Back up the transaction log for the database to free up some log space."
>
> thanks in advance

Relevant Pages

  • What is the best practice to create Maintenance Plans
    ... There is not a definitive answer to the question of which backup is better. ... the database can be recovered to the point ... Full Recovery or Bulk-Logged Recovery model. ... Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint and SQL Recovery Model
    ... SQL Server 2000 uses recovery models to help you plan backups. ... You can use either Simply or Full Recovery Model based on your need. ... be recovered to the point of the last backup. ... The SharePoint Portal Server 2003 configuration database. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How can I assign the result of dateadd to a variable ?
    ... It then stays in the database until 4 days later when it ... I now check the "Check Database Integrity" option with "Include Indexes", ... I have now changed the recovery model to "Simple" (In Enterprise Manager, ... > modifications since your last backup? ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL server 2000 truncate log command
    ... You will have to Backup the Tranbsaction log and Shrink the file. ... Please change the recovery model of your database to ... Change the recovery model to 'SIMPLE', Since you do not have hard disk ... Schedule a transaction log backup every 1 hour. ...
    (microsoft.public.sqlserver.server)
  • Re: restoring sql with VBscrip
    ... You must replace "MyDatabase" throughout with the actual name of your ... It is in the middle of a restore" ... a full backup. ... online documentation for RESTORE DATABASE. ...
    (microsoft.public.windows.server.scripting)