Server upgrade question

Hot Topic

SQL 2005 and SQL 2000, one Dev server, co-existence
beginner question - instances VS. separate databases?
Fit Table on one page if possible
How to reapply a trasaction log to a database?
Calling a stored procedure that inserts records and generates an output parameter
BI Dev Studio cannot connect ot SQL Server 2005
MSDE can live together with sql express?
Package running other packages
How to control CLR memory threshhold?
How to change data Dynamically in report services

SQL Server

Long line of text error
Reporting Servers - Export to Multiple tabs in Excel
RS 2005: Excessively Long String error when printing
refresh data best way?
IDENTITY fields
Rounding error: Between flat file connection manager Source & OLE DB Connection Destination (SQL Server 2005)
If-structure
What does the componentMetadata.FireError method do?
Memory Error
Problem inserting data in SQL express

Server upgrade question

We plan on doing an in-place upgrade of our SQL 2000 server.  It is currently on 2000 Server and the plan is to upgrade it to Server 2003. 

Are there any gotchas that I have to worry about with this, or is it a stright forward upgrade with few to no faults   I'm confident that the hardware will check out OK, so it's mainly SQL that I'm concerned about.

Thanks,
Aron

Answer this question

Server upgrade question

  • HannesThor

    There is a new tool called Upgrade Advisor. You can download any of the SQL Server 2005 Editions and install it - it will also be available as a stand alone download. The recommendation is you run this against your SQL2K instance to identify any known upgrade concerns.

    Dan

  • Server upgrade question
Answer this question