![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MS Server
fengzi_015
我抄啊抄啊,就抄到了今天这模样
展开
-
移动数据库日志文件
use mastergosp_detach_db @dbname='TestAttach'sp_attach_db 'TestAttach','C:\Program Files\Microsoft SQL Server\MSSQL\Data\TestAttach_Data.MDF','D:\TestAttach_Log.LDF'原创 2009-09-04 21:24:56 · 178 阅读 · 0 评论 -
清除日志
数据库KBMP的日志已满,请备份该数据库的日志以释放一些日志空间。处理办法:Use kbmpDUMP TRANSACTION kbmp WITH NO_LOGBACKUP LOG kbmp WITH NO_LOGDBCC SHRINKDATABASE(kbmp)EXEC sp_dboption 'kbmp', 'autoshrink', 'TRUE'...原创 2009-09-08 10:05:22 · 145 阅读 · 0 评论