Viewing post 1 (of 1 total)
change the schema name to yor database schema and run below scripts to truncate log (without backup log file) and shrink log file:
BACKUP LOG schemaname WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE ...
August 29, 2008 at 9:47 am
#865114