We have one Servers for our customers and another one for Reporting,

We have one key database for our customers which gets updated, and we have a log shipping for that...

The reason we have simple recovery is we do not use transaction log in case of recovery, we have the daily backup done on symantec

Everything looked fine to me, I had to restart the SQL Agent Job, and that make the notification working,

My Qusetion:

All our databases are in Simple Mode, we do not use transaction logs for recovery purposes, there is one database we have created the log shipping for, secondary server...

I will have the same version, I will upgrade them to SQL 2008 R2

I am still not receiving the notification after the job fails

Thanks

sorry, I am going to notification tab of job and select the email address

Thanks I will do that,

Sorry is Alert for the job failure

USE [msdb]

GO

/****** Object: StoredProcedure [dbo].[xp_sendmail] Script Date: 04/18/2012 13:21:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROC [dbo].[xp_sendmail]

@recipientsvarchar(max)=NULL,

@messagevarchar(max)=NULL,

@queryvarchar(max)=NULL,

@attachmentsvarchar(max)=NULL,

@copy_recipients varchar(max)=NULL,

@blind_copy_recipientsvarchar(max)=NULL,

@subjectvarchar(max)=NULL,

@typesysname=NULL,

@attach_resultschar(5)=NULL,

@no_outputchar(5)=NULL,

@no_headerchar(5)=NULL,

@widthint=9,

@separatorchar(1)='',

@echo_errorchar(5)=NULL,

@set_usersysname=NULL,

@dbusesysname=NULL,

--call parameters outside the range of old xp_sendmail call

@profile_namesysname=NULL,

@body_formatVARCHAR(20)='TEXT',

@importanceVARCHAR(6)='NORMAL',

@sensitivityVARCHAR(12)='NORMAL',

@query_attachment_filenameNVARCHAR(260)=NULL,

@append_query_errorBIT=0, ...

Alert of the jobs

What is the better way for me you suggest, data mirroring or replication, where I can get the best knowledge for replication please

You have a point here, The Reporting Server I have is 2008R2 and Primary is 2008

I want to make it standby/readonly as secondary server is just for reporting purposes