USE [TEST_new1]
GO
--清空数据库缓存
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
GO
BACKUP LOG [TEST_new1] with NO_LOG
GO
BACKUP LOG [TEST_new1] with TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE([TEST_new1])
GO
刪除sql2005 日誌
最新推荐文章于 2024-09-21 10:25:52 发布
USE [TEST_new1]
GO
--清空数据库缓存
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
GO
BACKUP LOG [TEST_new1] with NO_LOG
GO
BACKUP LOG [TEST_new1] with TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE([TEST_new1])
GO