Re: Transaction Log shrinking problems

Check to ensure you don't have any open transactions in the database. Try
using DBCC SHRINKFILE instead of EM.

--
Andrew J. Kelly SQL MVP

"Jiro Hidaka" <medisca@xxxxxxxxxxxxxxxxx> wrote in message
news:75109E67-EF07-4BFB-BDF4-AE0891A1506A@xxxxxxxxxxxxxxxx
Hello,

I was trying to restore a backup of a database file and got the error
below:

"MODIFY FILE encountered operating system error 112(There is not enough
space on the disk.) while attempting to expand the physical file.
Could not adjust the space allocation for file 'SysproCompanyM_log'.
RESTORE DATABASE is terminating abnormally."

I googled the problem and tried everything I got my hands on, like
shrinking
the log file through Enterprise Manager and Query analyzer but I cannot
get
the log file to shrink at all. It is a whopping 20 gig file and it wont
shrink to less than that.

Do you have any suggestions in regards to this?

Thanx in advance!



.

Relevant Pages

  • Re: Detach - Attach in SQL Server 7
    ... >> It is not rquired to detach and attach the database to shrink the file. ... If the log file really huge make the databse single user after ... >> DBCC SHRINKFILE('Logical_ldf_name','truncateonly' ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000: Cant get the trans log to shrink
    ... to the log file? ... the t-log backup appears to have worked. ... Manager> All Tasks> Shrink Database> Shrink Files ...
    (microsoft.public.sqlserver.setup)
  • Re: How to delete the transaction log to a reasonable size
    ... Looks like the recovery model for your database is FULL or BULK_LOGGED. ... log and shrink the LDF file. ... If you need the transaction log backup do:- ... Now execute the below command to see log file size and usage. ...
    (microsoft.public.sqlserver.server)
  • Re: Will this shrinkfile method work?
    ... There is no need to change the recovery model at all. ... If the active VLF is near the end of the log file it may take a little ... while for it to shrink but it will. ... Right click the database, choose TASKS - SHRINK - DATABASE ...
    (microsoft.public.sqlserver.setup)
  • Re: How do I reduce the physical size of the file?
    ... Switch to the database we are attempting to shrink the logs for. ... DECLARE @LogicalFileName SYSNAME, ... Modified the inner loop so it tested the dx time so long overruns did not ...
    (microsoft.public.sqlserver.server)
Loading