Hi
I have a transactional log that size is 7286.12mb and space used is 548.42mb. When i shrink log to 1000mb i get something like this:
Current size: 7286.12mb and space used: 623.53mb.
I think that current size should be 1000mb.
Why current size still 7286.12mb.
thanks
alex

Try dumping the log, then the database. After that do your shrinkfile, but go only down to 2000 meg for starters.
If that works proceed to 1500 or a 1000. Those numbers still better than 7000.

--Verify the name of the log file.
select * from sysfiles

After you dump the log, run the following statement to shrink the file.
Use db_name
go
DBCC SHRINKFILE (name of log file, 100 --size you want To shrink to in meg--)
go
Example:
dbcc shrinkfile(abc_log, 100)
go

--Once that is done you can run this to shrink the database if you want. It can take some time when it comes to --larger databases, so choose the time you do it wisely.
use abc
go
DBCC SHRINKDATABASE (abc, 1000) size is megs once again.
GO