ITPub博客

点击(此处)折叠或打开--CREATE PROCEDURE gen_createtbl @tbl_name varchar(100) --AS set nocount on    --声明游标需要的变量     declare @tblname varchar(100), &nbsp...

点击(此处)折叠或打开USE [DBCenter]GOCREATE PROCEDURE [dba].[sys_tmp_monitor_85]ASbegintruncate table dbcenter..tmpdbmonitor_SQL insert into dbcenter..tmpdbmonitor_85 ...

察看AG group的面板，察看AG组是否正常，如果面板显示正常执行2的步骤，面板显示异常的请根据异常提示来执行操作，本篇内容不涉及处理这些异常执行以下语句点击(此处)折叠或打开select n.group_name,    n.replica_server_name, &nbsp...

USE master;GODECLARE @SQL VARCHAR(MAX);while 1=1SET @SQL=''SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)FROM master..sysprocessesWHERE dbid=DB_ID('datayesdb');EXEC(@SQL);waitfor delay '0:0:1' GO

use tempdb                                                               -- 每隔1秒钟运行一次，直到用户手工终止脚本运行while 1=1  ...

网上通常的做法USE master;GODECLARE @SQL VARCHAR(MAX);SET @SQL=''SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)FROM master..sysprocessesWHERE dbid=DB_ID('datayesdb');EXEC(@SQL);GOALTER DATABASE [datayesdb] SET MULTI_USER 上面的方法不好用,然后求助lg帮忙终于弄好了,吓死吓死我了明天得找阿三...

上周末发现db02组的alwayson 同步异常，所以权衡了各个方法后决定采用重新加载DYY数据库的方式来修复异常。但是当在主库上执行全备和log备的操作时，发现以下的错误信息。The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or ...

备份时报错 

远程副本没有恢复到足以启用数据库镜像或将其联接到可用性组的程度。您需要通过从主体/主数据库还原当前日志备份，将缺失的记录日志应用于远程数据库。  (Microsoft SQL Server，错误: 1408)

use tempdbCHECKPOINT;GODBCC DROPCLEANBUFFERS;GODBCC FREEPROCCACHE;GODBCC FREESYSTEMCACHE ('ALL');GODBCC FREESESSIONCACHE;GODBCC SHRINKFILE (TEMPDEV2, 1024);   --- New file size in MBGOhttps://sqlsunday.com/2013/08/11/shrinking-tempdb-without-restarting-sql-server/...

alter procedure dba.GetMaxTMstmp @tbname nvarchar(100)asdeclare @Max_TMstmp bigintdeclare @sql nvarchar(4000)declare @sql2 nvarchar(4000)declare @i int=0--set @tbname='bond'--print @tbnamebegin--print @tbnameset @sql2='select @i=count(1) from sys.columns col join sys.tables tbl on ...

https://www.sqlshack.com/understanding-backups-on-alwayson-availability-groups-part-1/Log backup for database "test1_ag2" on a secondary replica failed because the last backup LSN (0x00000020:000000ad:0001) from the primary database is greater than the current local redo LSN (0x00000020:000000ac:0...

SELECT    SERVERPROPERTY('MachineName') AS ComputerName,  SERVERPROPERTY('ServerName') AS InstanceName,    SERVERPROPERTY('Edition') AS Edition,  SERVERPROPERTY('ProductVersion') AS ProductVersion,    SERVERPROPERTY('ProductLevel') AS ProductLevel, ...

https://docs.influxdata.com/influxdb/v1.2/guides/writing_data/http://1316478764.iteye.com/blog/2100778

一、先启动邮件服务SQL SCRIPTS exec master..sp_configure 'show advanced options',1  goreconfiguregoexec master..sp_configure 'Database mail XPs',1goreconfigurego二、创建发邮件时所需要的account 点击(此处)折叠或打开exec msdb..sysmail_add_account_sp  @account_name = 'OPS...

exec master..sp_configure ,1 go exec master..sp_configure ,1 go

1、 备份数据库在主副本上，将需要做AlwaysOn的数据库做一次全备和日志备份（NOTE：禁用事务日志备份作业，如果有的话）替换参数，执行如下脚本生成备份语句，然后执行：DECLARE @DBNameNVARCHAR(255)DECLARE @SQLNVARCHAR(MAX)DECLARE @BackupToPathNVARCHAR(500) SET @DBName='dat...

1.下载最新包wget https://files.phpmyadmin.net/phpMyAdmin/4.6.6/phpMyAdmin-4.6.6-all-languages.tar.gz

1.下载最新包wget https://files.phpmyadmin.net/phpMyAdmin/4.6.6/phpMyAdmin-4.6.6-all-languages.tar.gz

1、安装apachesudo apt-get install apache2为了测试apache2是否正常，访问http://localhost/或http://127.0.0.1/，出现It Works！即是安装成功。2、安装mysqlsudo apt-get install mysql-server安装过程中MySQL要求设定账户有密码，这是与操作系统没关系的账户与密码。3、安装相关模块sudo apt-get install libap...