SQL Server Troubleshooting
文章平均质量分 71
KevinLiu
SQL Server MVP
展开
-
SCCM:Setup has encountered fatal errors during database initialization.
今天同事在安装SCCM2007,结果装到一半出问题了。我过去看了一下是数据库权限不够,然后看了一下安装文档安装上面的要求相应的增加了权限。 但是重新安装的时候还是报错,这次的错误跟上次不一样了: “Setup has encountered fatal errors during database initialization. Contact your SQL administrator.原创 2012-07-24 08:18:51 · 2162 阅读 · 0 评论 -
Msg 3159 The tail of the log for the database "" has not been backedup
还原数据库文件组的时候出现下面的错误: Msg 3159, Level 16, State 1, Line 1 The tail of the log for the database "testfile" has not been backedup. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work原创 2013-02-05 09:44:57 · 1736 阅读 · 0 评论 -
Error number: 20598 The row was not found at the Subscriber when applying the replicated command.
今天测试Replication遇到下面的错误: The row was not found at the Subscriber when applying the replicatedcommand.(Source: MSSQLServer, Error number: 20598) if @@trancount > 0 rollback tran (Transaction seque原创 2013-01-23 10:42:41 · 2089 阅读 · 0 评论 -
SQL Server 2005 没有本地发布选项
在论坛看到一个帖子说自己的数据库使用SSMS打开只显示本地订阅没有本地发布,截图如下: 因为SQL Server 2005 Express是只有订阅功能没有发布功能的,所以当时考虑可能安装的是Express版本。来自MSDN( SQL Server Express 的复制源自在SQL Server 2005 中创建的发布。运行SQL Server 2005 的计算机为发布服务原创 2013-01-15 09:57:49 · 3675 阅读 · 0 评论