首頁 > 資料庫 > mysql教程 > SQLServer2005 remove log file.

SQLServer2005 remove log file.

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
發布: 2016-06-07 15:34:54
原創
1339 人瀏覽過

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
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板