Ms SqlServer
文章平均质量分 79
翁特锋
Oracle 博大精深
展开
-
MS Sqlserver 2000 transaction log shrink step
First, review the transaction log size prior to the shrinking process.USE [YourDatabaseNameHere]GO SELECT * FROM sysfilesWHERE name LIKE '%LOG%' GO Second, set the database recover翻译 2013-07-09 13:47:23 · 684 阅读 · 0 评论 -
Replication error Agent message code 20002 due to OS error 2.
从SQLSERVER 2012到Oracle 11204 的Replication异常中断,错误信息:Agent message code20002. The process could not create file 'D:\Program Files\Microsoft SQLServer\MSSQL11.MSSQLSERVER\MSSQL\ReplData\unc\SQLTEST原创 2017-11-17 15:23:08 · 1094 阅读 · 0 评论 -
SQLSERVER Negative SQL Server SPIDs(Unit of Work ID)
一、场景当MSSQL数据库是所在的windows server 启用了MSDTC 服务二、概念A session with SPID equal to -2 is an orphaned distributed transaction. A distributed transaction is a database transaction that calls databases hosted on different servers. Orphane原创 2017-08-15 14:19:44 · 975 阅读 · 0 评论 -
Skipping Errors in Transactional Replication on SQLSERVER 2012
玩过Oracle Golden Gate的网友都知道,OGG在配置参数文件中,可以通过增加ignore error的参数屏蔽一些引起复制终端的错误。Sqlserver Replication 也是一样。SQLSERVER 提供了SKIPERRORS这个参数可以忽略此类错误:https://technet.microsoft.com/en-us/library/ms151331.aspx原创 2017-06-02 15:13:13 · 1052 阅读 · 0 评论 -
Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION
SQL Server 2008 R2 In some cases, it is desirable for user activity in a replication topology to be treated differently from agent activity. For example, if a row is inserted翻译 2017-05-15 17:40:53 · 720 阅读 · 0 评论 -
MSSQL 2008 database storage migration on windows 2008 cluster
Migrate storage for MSSQL 2008 ON windows 2008 cluster原创 2017-01-05 15:49:54 · 989 阅读 · 0 评论 -
MSSqlserver 恢复sa密码及 删除builtin\administrators后恢复
MSSqlserver 恢复sa密码及 删除builtin\administrators后恢复原创 2016-04-28 09:22:07 · 2518 阅读 · 0 评论 -
SQLSERVER 2012 Reinitial single article
The initial SnapShot for Article "xxx" is not yet available 处理方法原创 2016-10-11 17:33:07 · 933 阅读 · 0 评论 -
SQLserver Monitor( By Snapshot) Configuration
1.使用版本:SQLSERVER 2008,2012 2.功 能:监控 lock,SP_WHO2,IO性能等,同时配置邮件发送功能3.监控脚本:@echo offrem rem Purpose: Schedule Database Performance Monitoring rem Written By:原创 2015-07-07 11:17:51 · 1275 阅读 · 0 评论 -
SQLserver 邮件分发配置脚本
该脚本用于配置sqlservere 数据库监控邮件分发、事务监控、锁监控原创 2015-07-07 11:35:54 · 1305 阅读 · 0 评论 -
TDSSNIClient initialization failed with error 0x2, statuscode 0x1.
when SymptomsCannotopen SQL server configuration manger and not start SQL server service.In windows Event log:SQL Server could not spawn FRunCM thread. Check the SQLServer error log and the原创 2014-06-06 13:58:27 · 3052 阅读 · 0 评论 -
SQLSERVER 2008 restore database 错误一列(ocrr Msg 3176, Level 16, State 1, Line 1)
偶然一次开发人员要求将一个uat环境的Sqlserver 2008 restore 一个database 的时候遇到 Msg 3176, Level 16, State 1, Line 1 这种报错:备份的文件:db_c3_gzct_uat_tips.mdf.bakMsg 3176, Level 16, State 1, Line 1File 'D:\Progr原创 2013-12-18 13:52:45 · 3023 阅读 · 0 评论 -
SQLSERVER 2012 HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING 等待事件
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING A query on object(s) in a readable secondary database of an AlwaysOn availability group is blocked on row versioning while waiting for commit or rol...原创 2017-12-13 08:56:20 · 1047 阅读 · 0 评论