Re: Transaction Log shrinking problems

Perhaps these links will help.

FileSize -Log File Grows too big
http://www.support.microsoft.com/?id=317375

FileSize -Log File issues
http://www.nigelrivett.net/TransactionLogFileGrows_1.html

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


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"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!



.

Loading