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.
Re: MuOnline.ldf log deleting, truncating
Re: MuOnline.ldf log deleting, truncating
.ldf log still growing.. Please help. SQL 2008
Re: MuOnline.ldf log deleting, truncating
USE MuOnline;
GO
ALTER DATABASE MuOnline
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (MuOnline_Log, 1);
GO
ALTER DATABASE MuOnline
SET RECOVERY FULL;
GO
Re: MuOnline.ldf log deleting, truncating
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!