Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Skip to end of banner Go to start of banner

SQL2008日志收缩/数据库优化

Skip to end of metadata

Created by 辉煌 on Jun 30, 2022

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

1、备份当前数据后，首先打开SQL Server Management Studio，找到要操作的数据库。鼠标右键点击数据库，在弹出菜单中选择属性。

2、选项--恢复模式--选择【简单】

3、右击数据库——任务——收缩 ——（数据库/文件）——确定

4、右键--属性--选项将恢复模式修改成“完整”

No labels