yes that is correct.  The reason being is that i am creating a backup server that is identical to the production server and well the path on that is e:\mssql7...

Thanks a TON for the help..much appreciated...

Mostly just dont forget the logins and users .  Also make sure you address the backups as said above.

Doing an inplace upgrade and the status in the cluster administrator 2003 says everything is good. This is why i am not understanding whats going on.  Thanks for your help

I think the 2 minutes lag time is borderline acceptable but you have to remember this.  Is it 2 minutes everytime that db is hit? or just initially.  Also it...

Did you try to run a DTS for the same set up?  DTS in my findings usually run a bit faster then BULK INSERTS, with the same ending.

Thanks to everyone.... the help is much appreciated and helped me to see it all from a few different views... 

ok here is the original query...  hope this helps and yes it does work fine as is...  tried to simplify before seems to have caused problems..sorry

SELECT Opportunity.Opportunity_Id,Opportunity.Rn_Create_Date,Opportunity.Opportunity_Name,

Opportunity.Expected_Revenue_Date,Opportunity.Status,Opportunity.Prod_Div_Ch_Partner,

Opportunity.Weighted_Amt,Opportunity.Raw_Total,Opportunity.Opportunity_Id,Opportunity.Partner_Type,

Product.Product_Code,Company.Zip,Company.State_,Company.City,FE_Code.FE_Code,Employee.Last_Name,

TTID_23R2826R2833.Last_Name,TTID_101R2850R2864.Product_Line_Code,TTID_58R987L949.Competitor_Name

FROM (((((((Opportunity  LEFT...