Thank you for your answers.

It should be hard to maintain two servers with a real time replication. isn't it ?

I think that we will choose a SQL cluster.

I found !!!

This is a problem on the cluster. The 1433 isn't listening on the virtual server but only the physical server.

And the application doen't use the same mode of...

thank you for your answers.

Both DB uses the same connection string.

I use sa to be sure that it's not an autorization problem.

Hi,

I have an instance and 2 DB.

So is it possible to have different network configuration here ? I hope not !

Yes it helps me. My server is SQL server 2000.

But I cannot change collation when the column is indexed and other fun alert of SQL server.

How do you do...

OK dbcc shrinkfile (2, 100,TRUNCATEONLY)

I trace

transaction/sec

memory

CPU

Is it enough ?

Which parameters should I analyse to check the performances ?