MSSQLSERVER
jxzkin
这个作者很懒,什么都没留下…
展开
-
MS SQL Server收缩日志文件
1.dbcc sqlperf(logspace) 2.sp_helpdb 3.dbcc shrinkfile ('log_name', size[m]) #先备份 #没有空间情况-调整恢复模式为简单 Backup log BGI to disk='H:\INTEL_TRAN_DUMPS\INDIVT01\BGI\bgi_log.bak' 4.dbcc shrinkfi原创 2012-11-01 13:50:25 · 611 阅读 · 0 评论 -
MSSQLSERVER CAN NOT START AFTER ENABLE & DIABLE VIA
Resolution: 1. stop sql server 2. open "SQL Server Surface Area Configuration" and disable remote connection 3. start sql server 4. stop sql server 5. open "SQL Server Surface Area Configura原创 2011-11-24 08:15:39 · 566 阅读 · 0 评论 -
SQL Server管理
-- 查看blocking select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name from sysprocesses where spid in ( select blocked from sysprocesses where blocked 0)原创 2013-12-30 14:01:50 · 631 阅读 · 0 评论