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 · 612 阅读 · 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 · 567 阅读 · 0 评论 -
SQL Server管理
-- 查看blockingselect spid, blocked, loginame, last_batch, status, cmd, hostname, program_namefrom sysprocesseswhere spid in( select blocked from sysprocesses where blocked 0)原创 2013-12-30 14:01:50 · 632 阅读 · 0 评论