Applying Service Packs

Are there any guidelines or best practices for deploying or testing Service Packs? What types of tests should be performed prior to upgrading or do I just trust Microsoft?I always put them on test machines first for a month or so. Enough time that some applications have had a testing cycle, anyway. If there are no major complaints, the first production guinea pig is selected, and watched for a week. If no major problems come up, then the rest of the machines get it. never trust Microsoft. They are human, too...well, half human.|||That's the way to do it. We have dev, test, and production environments. Dev gets the release 1st, and if no one screams after a couple of weeks, we apply it to test. Again, the absence of any wailing and gnashing of teeth means we move to production.

Plus, an added benefit is that you get to practice the install in case something goes horribly wrong (oh my ... would that ever happen?)|||Definitely agree with the two previous posters. In addition, read the release notes, particularly if you have a clustered environment or one where you use replication (upgrades MUST be done in a certain order when replication is involved)

Lempster|||Thank you all!! Pretty much thought so, but just wanted to see how others were handling it. :)

Anything specific about SQL 2000 64 bit ?

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 tools
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 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..
>
>

Anything specific about SQL 2000 64 bit ?

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..
>
>

Anything specific about SQL 2000 64 bit ?

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 tools
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 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..
>
>