Chris, I think this is the first time I have heard this best practice.  Are you referring to stand alone drives?  On our datawarehouse server, we have all of our...

Have you also found that drivers are more widely available for the 64-bit OS? I know that was an initial complication but I would assume that HW vendors are catching...

Thanks for the feedback everyone!  As far as 64 bit, are you running the 64-bit OS or the 32-bit OS on the 64 bit hardware?  If 64-bit OS, any issues...

Steve,

Thanks for the reply.  We are running SQL 2000 Enterprise Edition.  We are looking at going to SS2k5 with this new box as well as 64 bit technology. 

We keep...

In our environment, we observed that it was doing approx a 20-30% compression.  So a 10 GB database was creating a 7-8 GB backup file. 

As a sidenote, we just...

No McAfee.  We are using Norton AV.  I will have to check the windows firewall but I don't think it is blocking the port.

I don't think so. On the server, I checked & it was the default port.  On the client, I checked & it was the same port.

I did check the server & TCP/IP & Named pipes are enabled.  At least under the server network utility they are. There isn't another place I need to check, is...

TCP/IP & Named pipes are the protocols that are listed as enabled on the server.  Port 1433 for TCP/IP. 

I don't believe the server is aliased as anything else.

Interesting, I...

Yes, I am using a domain account for the SQL Service & the SQL Agent Service.  The SQL Service account is a local administrator on both SQL Servers.  The SQL...

Ok, thanks for correcting me on this!  This is my first experience with needing to use any of these switches.  The server we are working on had the AWE enabled...

Thanks for the link!  A very informative article.  So currently I should disable AWE & put the /3GB switch in the boot.ini.  In the near future we hope to put...

Gift,

As far as I know, the only requirement for AWE is that you have more than 2 or 3 GB of RAM.  We currently have AWE enabled on our server...

Gift,

What are you referring to when you say you need a special Intel chip to enable "it"?  What is it?

Thanks,

John

No, I didn't try that because I never received any error messages issuing the statement the way I had it.  I would think that if there was an issue, it...