Thank you!!!

I know both have toll. what would you do on production db backup? only CHECKSUM? CHECKSUM AND RESTORE VERIFYONLY? OR VERIFYONLY?

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?...