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 · 2137 阅读 · 0 评论 -
Msg 3159 The tail of the log for the database "" has not been backedup
还原数据库文件组的时候出现下面的错误: Msg 3159, Level 16, State 1, Line 1The 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 · 1687 阅读 · 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 · 2043 阅读 · 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 · 3647 阅读 · 0 评论