In addition These 2 servers has different function ( and different databases ) so this migration is for Consolidation purpose ( easy to manage )

Thank you very much guys !

Really appreciate your feedback

Thanks for the reply . Much appreciate it !

I am gonna run SQL Profiler tonight (the lighter method so It won’t impact sql performance) for 30 minutes between 8:45 pm...

Thanks for the reply .

So the number of very slow calls are spiking . I checked full backup but no conflict with it

Any idea what to check ?

Thanks Gail . I will take a look if i can fix or remove it

Hi guys

Many thanks for the reply . Recovery mode is FULL

Log backup is running well every 3 hours and I notice the replication is failed . Log is full...

Thanks for the reply guys .. Appreciate it

Regarding Tempdb, I don’t create it anymore . So it’s already there.

I only migrated 1 database .

So do you still see any...

Hi , Btw I still have a feeling that I don’t need to change the collation of Database which is migrated from Server A to Server B . Because in...

Hi…Thanks so much for the reply . Really appreciate your effort !

OK I feel that’s a lot things to do ( many steps ) . I would prefer to...

Hi ,

Out of curiosity if we only run this query :

SELECT A.F_Name, A.LName ,

A.Data , A.Email, A. UserName, A.type, A.Zip, A.A_Id , A.Create_Date,

A....

Thanks Marcus !!

It works now .. Thanks for sharing ?

Hi Gail ,

Appreciate your feedback .

I did enable LOG Extended Information from Reporting and Logging ( Maintenance plan ) . I am not 100% sure that this is what you...

Thanks for the feedback

I check the logging, it is successful

The result as below :

Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.6000

Report was generated on "ABC".

Maintenance Plan: DBCC

Duration: 00:04:38

Status: Succeeded.

Details:

Execute...

Hi guys

You are right ! Where criteria is pointless haha

It’s not me who write this . I guess someone who worked as a constructor wrote it and gone...

Thanks for the feedback .

What do mean by Query hint in this case ?

I assume you are referring to “OPTIMIZE FOR “ (Instructs the query optimizer to use a particular...