Re: Still problems with space

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 10:16:45 +0530

Hi,

Can you tell me the File growth mentioned for Transaction log file.

How to check:
-----------------
IN Enterprise manager -- Select Databases -- Right click above the database
name and
click properties and go to traansaction log .

If the growth size mentioned is % , and if it s 30%, the file will try to
grow for 2.2 GB (30 % of 7.2 GB). In this case system will not be able to
allocate that space and the growth will not happen.

How to reduce the file size:-
-----------------------------

How to reduce the Transaction log size

1. Backup the transaction log (Use BACKUP Log dbname to
disk='c:\backup\dbname.tr1' or use enterprise manager)

or (Since you done have the hard disk space truncate the trasaction log)

backup log <dbname> with truncate_only

3. Shrink the transaction log file.

   DBCC SHRINKFILE('logical_transaction_log file name','truncateonly')

Have a look into the below link.

Shrinking the Transaction Log in SQL Server 2000 with DBCC
http://www.support.microsoft.com/?id=272318 

--
Thanks
Hari
MCDBA
"John" <John@discussions.microsoft.com> wrote in message
news:3CA20701-7DA6-46CF-A3F7-FAE0AFD178CD@microsoft.com...
> Hi,
> I am working with a sql server 2000 accounting database where the mdf file
is 465 MB while the ldf file is 7.2 GB. The server has still 2 GB space
left. However when I am going to the database property it shows only 65MB
space left. This also does not allow the application to run. An error comes
up instructing to backup the log file.
>
> q1) Why the database is showing only 65 MB of space when the NT server has
2 GB of space available i.e. why does the database not utilitze the
available 2 GB space?
> b) The ldf file is unusually big. Does backing up the ldf file release
major space?
> Thanks in advance.

Relevant Pages

  • Re: Transaction Log Size
    ... listed in my article has detailed info on shrinking of the transaction log. ... Tibor Karaszi, SQL Server MVP ... > (database + transaction log) with fake appended to the name. ... >> CommVault to backup the backup files. ...
    (microsoft.public.sqlserver.server)
  • Transaction log problems
    ... We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... transaction log and it is causing us some problems. ... Because the database is used by the third party software, ... transaction log file and I would not have to monitor it so closely. ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction log problems
    ... IF you have to shrink a database or file it ... sure that you get that database backup on tape or to another machine. ... > We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... > One of the databases has recently begun showing large growth of the> transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)
  • RE: Backup in maintenance plan
    ... I selected "Back up the transaction log of the database as part of the ... To ensure an efficient and effective backup and recovery strategy for your ... The transaction log should not be backed up if the truncate log on ...
    (microsoft.public.sqlserver.programming)
  • Re: 1105 - log file getting full - SQL Server 6.5
    ... Follow Hari's instructions, backup the transaction log on a regular basis, ... Wayne Snyder, MCDBA, SQL Server MVP ... > Can't allocate space for object 'Syslogs' in database ''corp'' because ...
    (microsoft.public.sqlserver.server)
Quantcast