We are running Win2k Advanced Server with SQL 2000 Standard Edition and I am confused as to what will/won't work with that combination.

Does /3GB work with Win2K ADV Server and...

The old server has:

4 x 200mhz Pentium Pro

1 gig ram

1 x 36 gig drive for os/apps/raw ftp files/log

4 x 36 gig RAID 1 for the DBs (72 gig usable space)

New...

I just changed my DTS PACKAGE to store the data in a new table setting all the NVARCHAR fields to VARCHAR. These tables have the same data in them,...

thanks - the file copy finally worked 24 hrs later

just had to do db detache/attache once the file was on the new server

so far so good - already seeing benefits

db...

thanks down time is an issue but too late for that it is down

also old and new system use different raid configs

the 67 gig file is on a 72 gig...

Thanks!

I was planning on keeping/backing up the CLEAN data folder on the new server.

I have done this before that way but both were running SQL7 so now throwing in a...

Thanks - so you suggest

1. Install the SQL2000 on the new server and define the install directories as they are on the old SQL7 server (letter:\mssql7\data)

2. Upgrade the SQL7 server...

Based on the SQL Performance Document I figured there would/could be a channel conflict but the people who do our buying did not want to listen to me. And just...

Here is what I got going right now for a test on the server:

2x18 as RAID1

2x18 as RAID1

These are spanned so it is really RAID10

This is for the os/apps/raw data...