MuOnline.ldf log deleting, truncating

Please. help fast me 100GB of logs data! What query code for sql server 2008 must be? version 97d.

- - - Updated - - -

backup log MuOnline with NO_LOG
backup log MuOnline with TRUNCATE_ONLY
DBCC SHRINKDATABASE(MuOnline)


Answer what sql 2008 giving me:

Msg 155, Level 15, State 1, Line 2
'TRUNCATE_ONLY' is not a recognized BACKUP option.

just shrink Database

Video : http://www.youtube.com/watch?v=gyeSBl34MdI

.ldf log still growing.. Please help. SQL 2008

USE MuOnline;
GO
ALTER DATABASE MuOnline
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (MuOnline_Log, 1);
GO
ALTER DATABASE MuOnline
SET RECOVERY FULL;
GO

Quote:

---

Originally Posted by hahn

use muonline;
go
alter database muonline
set recovery simple;
go
dbcc shrinkfile (muonline_log, 1);
go
alter database muonline
set recovery full;
go

---

big thanks for you!