• 技术文章 >数据库 >mysql教程

    SQLServer2005 remove log file.

    2016-06-07 15:34:54原创664

    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.

    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核实处理。
    专题推荐:SQLServer2005 remove log file.
    上一篇:空值排序(oracle和sqlserver) 下一篇:实战mysql存储程序与定时器
    VIP课程(WEB全栈开发)

    相关文章推荐

    • 【活动】充值PHP中文网VIP即送云服务器• mysql的日志文件是哪个• mysql的启动失败信息会保存在哪个日志中• mysql函数中可以用游标吗• 精选归纳15个Mysql优化问题• mysql中什么时候用临时表
    1/1

    PHP中文网