博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

03 2012 档案

DBMIRROR_DBM_EVENT

摘要：原文：http://blogs.msdn.com/b/grahamk/archive/2011/01/10/sql-server-blocking-caused-by-database-mirroring-wait-type-dbmirror-dbm-event.aspxI was looking at a problem this morning about long blocking chains caused by the wait type DBMIRROR_DBM_EVENT, and it makes an interesting case study about database 阅读全文

posted @ 2012-03-21 15:23 nzperfect 阅读(1142) 评论(0) 推荐(0)

SQL Server 2008 Uninstall - Restart Computer Failure

摘要：Today, I uninstalled the SQL Server 2008 on Windows Server 2003 and encountered an issue with "Restart computer", But restart computer many times, it was still this error.Finally, I got it from "http://ntsblog.homedev.com.au/index.php/2010/05/05/sql-server-2008-uninstall-restart-compu 阅读全文

posted @ 2012-03-12 16:30 nzperfect 阅读(592) 评论(1) 推荐(0)

SQL Server 2008 install SP3后，发布数据库log变得越来越大

摘要：起因：前一段时间在为一组sql server 2008 failover cluster安装sp3，之前是sq1.windows server 2003 enterprise 64bit + sql server 2008 enterprise 64bitfailover cluster 是active/acitve 双实例问题：在两个节点都install sp3后，发现有一个sql server实例在切换时（其实也就是在restart sql server service)，用SSMS连接时会显示“服务器处于脚本升级模式。此时只有管理员可以进行连接”，大概几分钟，之后就正常了，当时就并未重视 阅读全文

posted @ 2012-03-08 10:15 nzperfect 阅读(1243) 评论(3) 推荐(0)

SQL Server 2012 正式发布

摘要：SQL Server 2012 正式发布 2012.3.7pls refer:https://www.microsoft.com/sqlserver/en/us/default.aspxhttp://blogs.technet.com/b/dataplatforminsider/archive/2012/03/06/sql-server-2012-released-to-manufacturing.aspxhttps://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx下载sql server 2012 阅读全文

posted @ 2012-03-07 14:02 nzperfect 阅读(649) 评论(3) 推荐(0)