Index is created from another machine. Not killed the statement. Cancelled query from ssms. checked index creation in ideal time, but not completed execution. Issue in client location, which is backup taken from out production db.
What is the network latency like between the two machines?
Jason...AKA CirqueDeSQLeil _______________________________________________ I have given a name to my pain...MCM SQL Server, MVP SQL RNNR Posting Performance Based Questions - Gail Shaw[/url] Learn Extended Events