SQLServer2005 remove log file.

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.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!