Enable network connection for MSSQL SQLEXPRESS

https://blogs.msdn.microsoft.com/sqlexpress/2005/05/05/how-to-configure-express-to-accept-remote-connections/ STEP 1: Enabling TCP/IP First we must tell SQL Server Express to listen on TCP/IP, to do this perform the following steps: 1. Launch the SQL Server Configuration Manager from the “Microsoft SQL Server 2005 CTP” Program menu 2. Click on the “Protocols for SQLEXPRESS” node, 3. Right click on “TCP/IP” in the list … Číst dál

Backup and restore All DB Microsoft SQL server

Make Backup in SQL script DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup files DECLARE @fileName VARCHAR(256) — filename for backup DECLARE @fileDate VARCHAR(20) — used for file name — specify database backup directory SET @path = 'C:\Backup\' — specify filename format SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR … Číst dál

Zabbix adaptec scan

Zabbix Adaptec monitoring 1) add user parameter to “zabbix_agentd.conf” 1 UserParameter=custom.adaptec,/usr/bin/sudo /usr/sbin/arcconf GETCONFIG 1 | grep „Logical devices“ | awk -F „/“ ‚{print $5}‘ Item 1 2 3 Name=adaptecItem Type=Zabbix agent Key=custom.adaptec Trigger 1 2 3 4 Name=adaptecTrigger Expression={Adaptec RAID controllers:custom.adaptec.last()}<0 Multiple PROBLEM events generation=yes Description=Adaptec RAID failure visudo: 1 zabbix ALL=NOPASSWD:/usr/sbin/arcconf