SQLServer2005 remove log file.
- WBOYOriginal
- 2016-06-07 15:34:541253browse
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.
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：空值排序(oracle和sqlserver)Next article：实战mysql存储程序与定时器