Is there anything special needed to administer a 64 bit SQL Server ? We are
looking forward to deploying 64 bit on some servers and wanted to know if
there is anything I need to be aware of from an admin perspective,
installation,configuring, troubleshooting,etc..There is a doucment for 64 bit sql server, you can read it before moving to
64 bit platform.
Thanks, Regards, Vincent
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23QRBWFKmFHA.2080@.TK2MSFTNGP10.phx.gbl...
> Is there anything special needed to administer a 64 bit SQL Server ? We
> are
> looking forward to deploying 64 bit on some servers and wanted to know if
> there is anything I need to be aware of from an admin perspective,
> installation,configuring, troubleshooting,etc..
>|||There are two pretty important things you should be aware of relating to
administering a 64-bit instance of SQL 2000.
1) You cannot run DTS packages on the 64-bit instance. You have to have a
32-bit instance that will run the DTS packages against the 64-bit instance
databases.
2) The administrative tools (Enterprise Manager and Query Analyzer, for
example) have no 64-bit editions. Again, you have to run these tools on a
32-bit machine and connect to your 64-bit instance.
If you are planning on running 64-bit SQL 2000, I'm guessing you have an
Itanium machine (I think the 64-bit SQL 2000 edition is only for Itaniums).
SQL 2005 has both Itanium and x64 versions, with a more complete set of tool
s
and functionality. If you could work with 2005, you might be happier.
Bob Hodgman
"Hassan" wrote:
> Is there anything special needed to administer a 64 bit SQL Server ? We ar
e
> looking forward to deploying 64 bit on some servers and wanted to know if
> there is anything I need to be aware of from an admin perspective,
> installation,configuring, troubleshooting,etc..
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment