11 2024 档案

sql server 清空日志操作步骤
摘要：-- 恢复模式切换为简单模式ALTER DATABASE [YourDatabaseName] SET RECOVERY SIMPLE;GO -- 备份日志BACKUP LOG [YourDatabaseName] TO DISK = 'NUL:' ;GO -- 收缩日志文件，压缩日志为100M，此 阅读全文

posted @ 2024-11-28 14:49 itjeff 阅读(173) 评论(0) 推荐(0)

查看SQL Server数据库各表数据量与占用空间
摘要：SELECT SCHEMA_NAME(t.schema_id) [Owner], t.name AS TableName, p.rows AS RowCounts, SUM(a.total_pages) * 8 / 1024 / 1024.00 AS TotalSpaceGB, SUM(a.tota 阅读全文

posted @ 2024-11-28 13:17 itjeff 阅读(600) 评论(0) 推荐(1)

导航