thnx , also curious can i have both the jobs running in separate location , if yes how two different log backups can happen with out creating issues in terms...

thanks , but i believe copy_only will not take the full log , does it?

thanks , so it looks even mirroring will not work from sql 2008 to sql 2005?

we dropped the idea for important piece , in case you need to failover to mirror during any outage and if this trace flag is enabled then your replication got...

Thanks , can you please elaborate on SSPI part?

Thanks the issue is ,i need to get comparison in two data sources with same servername and different IPs but pivot will not show the source of IP.

Thanks ,I got it , the last ask is now i have sourceA with servername ABC and 5 IPs and SourceB with servername ABC with 3 different IP than source...

Thanks , i am looking it to display in same report so result set should show head to head comparison as shown below ,

ACC has extra server IP...

Yes below are the errors in sequence time desc

Time ...

we are using remote distributor and we verified Transactions were not able to go to distributor as well...

Still looking for script , sent PM and Email couple of times, appreciate if you can get me the correct one...

Thanks!!

I am also looking for correct script , could you please post it?

Dividing into parts to make easier to understand

1)fist step to get the date difference

outagedatecolumn outagedatediffcolumn in hours

date1 ...

Great Thanks all!!

thanks for your reply ,the ask is weekly archival process , as of now we are in testing phase and considering all the negative points pointed out before we implement...