Mr. george sibbald your replay is most valuable..Pl. Do't mistake me, I am reply the Mr. Perry question

Thanks

I am just asking secondary server movement to another location which was configured database mirroring setup?

what are the steps need to follow during movement activity? suggestion Pls.

For database backup taking on network dirve, Is it really require to enable XP_CMDSHELL feature in instance side? there may be security issues

Hi,

I am going to deploly at production database for Mr. Michal rebuild index script,

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

I have doubt as below parameter

@forceRescan 1 - forace scan and 0 = use existing...

I have changed Global Temp Table as per your suggestion

yes.. It is working fine.. and Grate solution given to me

Thanks a lot..

script working fine and get current database size..

but below filed data are not comming.. what could be issues?

Last_day_data_size

Per_day_Increment

Per_month_Increment

Thanks

ananda

1. Reorganize index

2. Rebuild index

Can we create both operation in one single jobs via Mintenance plan?

issuse is user not able to DML operation via application during Rebuilding and Reorganize index.

I have doubt, i am not checked Index keep online in maintenance plan wizard? that is...

state_desc is ONLINE..

not for all database.. only user database

Rebuild and Reorganize job took 40 min that time user not able to insert data thru application.. once completed job application...

GRANT EXECUTE ON [xp_sysmail_format_query] to [service account]

I have done permission of SQL Agent service account.. again same issues,

what could be worng above script.. Temp Table #Result rows not display...

Im also facing same problem, SQL server does not allowed for login any user.. also DAC connection is not working even enabled... so I have daily backup of master database...Just...

Ok.. understand.. Thanks for reply

1. High performance mode - there is some data loss due to ackownledgement not received to Principal server from secondary server ..( so how to resolve...

Is it any data loss after firing as below command? pl. confirm

Use master

Go

ALTER DATABASE <Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Thanks

ananda

Thanks for reply.. I have changed the script for email notification as below and sending email number of records not to be zero

select MACHINE, COUNT(*) as Instance

into #tableA

from PROD.dbo.CM_INSTANCE...

Email notifications working fine and there is no issues..also without if condition that script is working and received email alert from database..

I received lot of mail wheather rows selected or...