Not the error log. The standard SQL log files.

Thanks! Have a pleasant weekend.

Since we are on this topic, should the system databases also go on the SAN?

Ok. I mainly wanted to check if it is possible to use a 64 bit server with 32 bit SQL. Thanks for the clarity.

Licensing and availability issue. I agree it is best to use 64 bit for both products.

I'll see what we can do about this.

Yes it is somewhat complicated. The 64 bit server is much more robust that our current 32 bit. Sounds like we need to talk to the OEM that...

Thanks. That is a huge help.

Just a quick thank you. I will set the maximum at 12 gig with no minimum. This has been extremely informative.

Thanks. I agree about the ODBC but we are running a legacy app on that server. Before I retire I may see a replacement for it.

Thanks. I appreciate your help.:-)

Pardon my lack of knowledge. Is it possible to backup a 64 bit 2005 database and restore it on 32 bit sql2005?

Well shucks! I guess I'll have to upgrade our sql 2000 server to 2005.

Yahoo! More $$.

Yes, compatibilty is important. We will also be taking 64 bit 2005 backups and restoring them in 32 bit 2000. Careful testing will be needed.

Even when run as a sql agent job?

Ok. I will do the research. Thanks again.