Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
ALTER TRIGGER [scheme].[email_insert] ON [scheme].[opdetm] AFTER INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; EXEC msdb.dbo.sp_send_dbmail @profile_name = '1', @recipients = 'firstname.lastname@example.org', @subject = 'subject', @body = 'body', @query = 'SELECT order_no FROM INSERTED with (NOLOCK)', @execute_query_database = 'demo' END
|Replace Dates in query||14||38|
|SQL: launch actions one before the other||10||23|
|SQL Server 2012 r2 - Query results have 2 seperate results instead of 1||2||22|
|T-SQL Default value in Select?||5||26|