Once installing second instance, It will be active/active. The installation of second instance is same as the way you installed first instance. If you alrady have default instance installed, the...

If you can, try to reboot the machine. Any service pack installed?

You should monitor CPUs, Memory, I/O, Network and SQL Serevr's counters.

http://www.sql-server-performance.com/performance_monitor_counters.asp

http://www.sql-server-performance.com/performance_monitor_counters_io.asp

http://www.sql-server-performance.com/performance_monitor_counters_memory.asp

http://www.sql-server-performance.com/performance_monitor_counters_network.asp

http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp

Has 'BUILTIN\Administrators' login been removed/denied from SQL Server Logins?

If it is, To start SQL Server Agent from local system account, You have to grant 'NT Authority\System' account to access SQL...

quote:

---

My question is what is the advantage of putting the transaction logs on a seperate set of disks, to justify this...

quote:

---

The SQL Agent service runs under local system account. I also tried to assign the local administrator to it but the...

Try to set 'ANSI Quoted identifier' through ODBC administrator.

Can you run same query in another SQL Server? Could it be hardware problem?

Yes, It should work.

It is quite samll number. I have a table in size 70GB and over 73 Millions records.

Are you going to use same virtual name for your new SQL Server?

If you can setup SQL Server and configure disk resources same as the old SAN, I rather copy...

It is nothing to do with linked server. As long as your SQL Server service account in server2 is able to read files in share in server1, you should be...

Depends on the hardware you have and whether you backup to local disks, to disks in another server across the network and to the tape.

I am luck to have...

Depends on how did you setup your serverA and it may not work once the disk array has been moved to serverB.

I would suggest you doing following steps.

1. alwary make...

Check whether there are indexes defined in your table too. If you have clustered index on column1 then you don't need 'order by' in your statement.

Make sure your tempdb's size...