sh

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

From: fredy corea (anonymous_at_discussions.microsoft.com)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 10:41:06 -0800

when i launch the statement

USE HRMASTERDATA
GO
DBCC SHRINKFILE (hrMasterData_log)

I get this message:

Cannot shrink log file 2 (hrMasterData_Log) because all logical log files are in use.

What can I do?

Relevant Pages

  • Errors on DBCC SHRINKFILE(2)
    ... When I use dbcc shrinkfile to shrink LOG file, ... Cannot shrink log file 2 because all logical log files are in ...
    (comp.databases.ms-sqlserver)
  • Re: Errors on DBCC SHRINKFILE(2)
    ... When I use dbcc shrinkfile to shrink LOG file, ... DBCC SHRINKFILE ... Cannot shrink log file 2 because all logical log files are in ...
    (comp.databases.ms-sqlserver)
  • shrinklog
    ... I'm trying to shrink *ldf file and getting following message: ... Cannot shrink log file 2 because all logical log files are ...
    (microsoft.public.sqlserver.server)
  • Re: how can i delete transaction log
    ... If you dont 'care' about the data just set the database to SIMPLE RECOVERY ... The above setting will ensure that log file is truncated after ... > dbcc shrinkfile. ... > Please refer to help for dbcc shrinkfile command. ...
    (microsoft.public.sqlserver.programming)
  • Re: Does DBCC SHRINKFILE on a data file cause the log to grow?
    ... 1)Perfom BACKUP LOG file (it removes all inactive transaction) ... 2)Pefrom DBCC SHRINKFILE to reduce physical size of the log file. ...
    (microsoft.public.sqlserver.server)