Posts

Showing posts from October, 2019

Set Up a SQL Server Database Alert

Image
Connect to the instance using Microsoft SQL Management Studio Double Click SQL Server Agent Right Click on Operators and select New Operator USE [msdb] GO /****** Object:  Operator [ DBA]    Script Date: 6/9/2015 5:50:44 AM ******/ EXEC msdb.dbo.sp_add_operator @name=N' DBA',   @enabled=1,   @weekday_pager_start_time=0,   @weekday_pager_end_time=235959,   @saturday_pager_start_time=0,   @saturday_pager_end_time=235959,   @sunday_pager_start_time=0,   @sunday_pager_end_time=235959,   @pager_days=127,   @email_address=N'xxyy@z.com,   @category_name=N'[Uncategorized]' GO
MySQL Services and Utilities: Backup & recovery. Security. Replication. Cluster. Partitioning. Workbench. MySQL Replication : Replication enables data from one MySQL database server (the master ) to be copied to one or more MySQL database servers (the slaves ) Replication is asynchronous by default Startup Options for Replication Slaves Server ID  On the master and each slave a  unique replication ID in the range from 1 to 2 32  − 1 Example  my.cnf  file: [mysqld] server-id = 3 --log-slave-updates Property Value Command-Line Format --log-slave-updates[={OFF|ON}] System Variable log_slave_updates Scope Global Dynamic No Type Boolean Default Value OFF