首页 > 数据库 > mysql教程 > SQLServer2005 remove log file.

SQLServer2005 remove log file.

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
发布: 2016-06-07 15:34:54
原创
1326 人浏览过

Issue: SQL server does not work when the log file occupied all the disk space. Resolution: Remove the LOG file data . Step: 1. Backup your database. 2. Detach your database. 3. Check the close connection box. 4. Remove you log file or rena

Issue: SQL server does not work when the log file occupied all the disk space.

Resolution: Remove the LOG file data .

Step:

1. Backup your database.

2. Detach your database.

SQLServer2005 remove log file.

3. Check the close connection box.

4. Remove you log file or rename it from the data path.

5. Attach you DB mdf again.

6. Remove the LDF  item  from the warning dialog list.

7. Attach DB successfully, and there is a new LDF file will created with 500K.

 

 

相关标签:
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板