清除SqlServer AlwaysOn日志
--dbName为数据库名
use dbName
BACKUP LOG dbName To DISK = N'nul'
go
dbcc shrinkfile(dbName_log,0, TRUNCATEONLY)
go
dbcc shrinkdatabase(dbName,0, TRUNCATEONLY)
go
--dbName为数据库名
use dbName
BACKUP LOG dbName To DISK = N'nul'
go
dbcc shrinkfile(dbName_log,0, TRUNCATEONLY)
go
dbcc shrinkdatabase(dbName,0, TRUNCATEONLY)
go