Email not received from database even rows available as below query.. could suggestion me, what could be worng as below coding..I want receive email when rows available if no rows...

Ok. understand...

I changed EXISTS instead of NOT EXISTS..Mail not received because no rows selected that Query currently..

I have configured in SQL Jobs and run it every 5 mints then...

Thanks for reply..

I want send email the same query result.. But I don't want send mail if Diff value=0

could anyone suggestion me as below coding condition matching or not? if diff value = 0

if NOT EXISTS (Select A.MACHINE, A.Instance, B.InstanceA,

(B.InstanceA-A.Instance) as Diff from (select MACHINE, COUNT(*)

...

The below code working fine... I want send mail when difference data apperaing.. output like below, if Difference data = 0 don't want send mail.

Machine-CM6

Instance -23

InstanceA -19

Diff -4

EXEC...

GilaMonster (8/22/2013)

---

Is once a month often enough? Do you retain all your backups (full and log for month)? If not, what do you plan to do if the CheckDB picks...

Thanks for clarification,

I am going to configure DBCC CHCKDB for all database t monthly once.. could you suggestion me? shloud I go for thru maintenance plan or Mr.ola-allengren coustmize script?

I want to know one things,

Enable - Checksum option

if corruptions happend that database by automatically Database backup also failed, so we comes know and checking in error log any...

Hi Steve Jones, I have doubt CHECKDB and CHECKSUM.

DBCC CHECKDB - it is allocate the huge resource for checking database Integrity & consistancy operation.

CHECKSUM - it is verify page level...

I got it....

In my case current service pack is (sp1) already updated on Instance.

I could install SP3 only and not required latest CU12..

In SP3 included that hot fix as...

ok.. Thanks for replay

First update SP3 and then apply latest Cumulative update package 12 for SQL Server 2008 SP3, is it correct ?

Ok..

That error was fixed with CU6 of SP3.. SQL SERVER 2008 32 bit

Pl. confirm as below steps for updating SP3 and CU6

1. Install SP3

2. Install CU1, CU2....CU6 ( i need...

Thank you for replay

As per BOL, forcing service facilitates resynchronizing the databases (with possible data loss) when mirroring resumes and make it mirror database online..

Is it possible how much data...

I have doubt.. I have Mirror setup manual failover without witness server

If Principal server is down due to N/W or H/W issues, In this cause mirror database condition is Restoring...

Hi

ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Instead of above query, can we run as below query for make it online in MIRROR Database..? Mirror database always sychronizing/Restoring mode. wheather High performance...