- Use the SQL Query Analyzer
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO
- (replace XXX with the database name)
About
- Use the SQL Query Analyzer
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO
- (replace XXX with the database name)