Update: It working now after I went to 'Sql Agent'--- Properties---Alert system and checked 'Enable mail Profile' and restarted the SQL Agent.

Thanks Google :o)

Mr. Grant Fritchey

you said in previous reply 'They don't do the same thing' (VERIFYONLY AND CHECKSUM).

In your article you said 'Verifyonly: Another way you can ensure that your backups...

Thank you Gurus. Last thing just to confirm, I should do CHECKSUM on PROD db backups. Since Maintenance plan only does VERFIYONLY.

If I have a sql job do this...

No sir, I swear. I also surprised!!!

Thank you ScottPletcher, Alexander Suprun and GilaMonster

@ GilaMonster, Should I put Snapshot database's Data and Log files point (put it) to another server? Is it possible? I just don't want...

Thanks for your reply 🙂

I am trying to give some info so it might help I think. I am concern about first 2 rows (came out same table name) which is the biggest table...

Thanks for your reply. I have followings for your questions. Hope this helps.

1. Yes, 1 primary file group

2. I thought it is best practice to keep all data files same...

Great.Thank you

Does it mean the fails? if i set up notification will it send out an email?

Sorry, I still didn't get my answer. Generally which should run first? Rebuild index or Update statistics.

if i select 'All statistics' then should Index job run first and then update statistics? And how often should update statistic on large DB?

Thank you guys. One more question: Should update statistics job run first or Index rebuild job? Is it OK to use maintenance plan to run update statistic with column only?...

Thanks for the reply, one thing, will Agent job fail? or it run normally but shows on 'view history' (when I go thru all) that something is corrupted?

Thank for your quick reply. Would you please tell me what is the 'baseline' here. Should I update old statistics older than month or so? or..