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 阅读(52) 评论(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 阅读(165) 评论(0) 推荐(0) 编辑

导航

< 2025年2月 >
26 27 28 29 30 31 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 1
2 3 4 5 6 7 8
点击右上角即可分享
微信分享提示