服务器技术/网络安全
返回
登录/注册
在SQL Server 2000企业管理器里面收缩数据库日志
楼主
Xinsoft 于 2005-03-26 10:51:10
在SQL Server 2000企业管理器里面收缩数据库日志
操作环境:Windows 2000 Advanced Server 英文版 + sp4、SQL Server 2000英文企业版+sp3
任务描述:
在企业管理器里面收缩数据库日志
以下为操作截屏:
回复
1楼
Xinsoft 于 2005-03-26 10:52:06
第一步:在你要收缩的数据库上面点鼠标右键:
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1001.104820.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1001.104820.jpg[/URL]
Pic by Xinsoft, 2005-03-26
回复
2楼
Xinsoft 于 2005-03-26 10:57:08
第二步:改数据库灾难恢复模式为Simple(简单模式)
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1002.105337.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1002.105337.jpg[/URL]
一般情况下这个属性的值是“Full”(完全备份)。这样的话有利于将来我们用日志来恢复数据。
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1003.105554.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1003.105554.jpg[/URL]
但是现在为了收缩数据库日志,我们将它设为:Simple(简单模式)
Pic by Xinsoft, 2005-03-26
回复
3楼
Xinsoft 于 2005-03-26 10:59:30
第三步:在数据库上点鼠标右键,选择:shrink Database(收缩数据库)
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1004.03583.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1004.03583.jpg[/URL]
Pic by Xinsoft, 2005-03-26
回复
4楼
Xinsoft 于 2005-03-26 11:03:25
第四步:
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1005.0303.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1005.0303.jpg[/URL]
在这个操作界面中,点“Files”(文件组)按钮。
注意在这里我们可以填写我们希望收缩后保留的大小。
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1006.01142.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1006.01142.jpg[/URL]
在“Database Files”下拉列表中选择要收缩的文件
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1007.02215.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1007.02215.jpg[/URL]
选择日志文件
Pic by Xinsoft, 2005-03-26
回复
5楼
Xinsoft 于 2005-03-26 11:04:41
第五步:点“Ok”执行
[IMGA]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1008.04417.jpg[/IMGA]
[URL]http://www.chinalabs.com/resource/upload/pic/2005/03/26/834399868.1008.04417.jpg[/URL]
Pic by Xinsoft, 2005-03-26
回复
1
2
电脑版
Page created in 0.0938 seconds with 4 queries.