Sorry,

my mistake - other one is 2K SP4 with additional hotfixes.

Still have same behavior from time to time. I found that other people have same problem, even there is a...

I presume that it's not a SQL Server fault. However it's not clear are you using MSCS or it is a just single server with single path on SAN?

Or you...

You need to change script to include owner of object. It should look something like this:

DECLARE updatestats CURSOR FOR

SELECT table_schema,table_name FROM INFORMATION_SCHEMA.TABLES

where TABLE_TYPE = 'BASE TABLE'

OPEN updatestats

DECLARE @tableschema NVARCHAR(128)

DECLARE @tablename...

I'm not sure what do you think when you're saying that db's are upgraded automaticaly even if you done side-by-side installation of SQL2005? It cannot happened...

For set up db mirroring...

a few tips:

- Pagefile: keep it on same size no matter of disk allocation. That means that you need to set min and max size of the same value. This...

You should be aware that SQL Collations are going to be depreciated.

Another thing is use of TERTIARY_WEIGHTS function that could kill performance of any server if you use SQL...

The main step in your case is upgrade to 2005 version of database. Once upgraded cannot be simple restored/attached.... on SQL 2000 version. Only way back is one of the...

Hi,

agree with previous post.

In addition please refer to http://support.microsoft.com/kb/291988, since these things (/3GB, /PAE, AWE) are different, and http://support.microsoft.com/kb/274750.

/3GB changes default user space/kernel space from 2/2 to...

Hi,

its not clear what you try to do?

- If its just moving database that resides on those disks with IBM RAID controller that you've mentioned, than it looks like it...

Hi,

the best way, speaking from my experience (dozen of cluster sql installations on 4-way.8-way boxes), is to leave hyperthreading disabled. SQL 2000 is simply not written well to use parralelism...

that is that matters

cheers

Hi,

What kind of error SQL reports, when you said that failover server fails to use the replicated database files? Does failover SQL see MV target disks?

So far, I have two...