Yes you can. Simply move everything however you plan on doing it. Then once the original servername is off the network have the dns alias of the same...

We are in the habit of creating an alias for the SQL Server name so when the hardware is replaced all we do is simply point the dns alias to...

Thanks Lowell. WOrks like a charm!

We have used VMWare to clone an existing SQL Server. However, the purpose of this was to move the install from older hardware to new hardware. It works...

I see it now. You are right. Sorry for the thread.

Congratulations Barry Larkin. The 40th Cincinnati Red in the Baseball Hall of Fame!

I have it enabled on all of our SQL Servers but set a max memory on all of them as well leaving plenty of memory free on the server. ...

What version and service pack level are you on? Is this a larger DB/Table? I had this problem and it can be very difficult to pinpoint what the...

Scheduled jobs that have been running for two years Integrity Check and Update stats started failing with the above listed error. I did nothing to resolve it.... a...

In doing some further testing we noticed that it was NETWORK IO... then it dawned on me... the two servers are in different data centers.... dumb me....

Clustered index scan 100% on both on the primary Key. For simplification I am now simply running a select * from xtable... nothing complicated just a simple select.

Both...

Well I have narrowed it down to opening up Mgt Studio and running a select from the linked server table and in SQL 2000 it runs 30 seconds.... in SQL...

Bizzare.... just bizzare.... the jobs are succeeding now....

Thanks everyone for your input.

The server typically is hardly used ever at all... memory is good, CPUs are very low all of the time.

The Remote Query timeout is currently set to 600... I bumped...

nothing has changed as far as I know.... Why would changing the IP address cause a timeout error though? THere is no dns alias on this server. ...