dbTalk Databases Forums  

SQL 2005 Upgrade Taking a Long Time

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss SQL 2005 Upgrade Taking a Long Time in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
childofthe1980s
 
Posts: n/a

Default SQL 2005 Upgrade Taking a Long Time - 08-13-2009 , 09:14 AM






Hello:

I am upgrading from SQL 2000 SP4 to SQL 2005. The upgrade of database
services is taking a long time.

The progress bar at the bottom is only on the 6th "block", and it has been
there for over 30 minutes.

Granted the databases are fairly large. One is over 4GB. There are about
18 databases. And, Task Manager says that the process is still running.

But, should it be taking this long?

childofthe1980s

Reply With Quote
  #2  
Old   
Linchi Shea
 
Posts: n/a

Default RE: SQL 2005 Upgrade Taking a Long Time - 08-13-2009 , 10:13 AM






It's hard to tell whether 30 minutes are too long. I've seen upgrades taking
longer than that.

Linchi

"childofthe1980s" wrote:

Quote:
Hello:

I am upgrading from SQL 2000 SP4 to SQL 2005. The upgrade of database
services is taking a long time.

The progress bar at the bottom is only on the 6th "block", and it has been
there for over 30 minutes.

Granted the databases are fairly large. One is over 4GB. There are about
18 databases. And, Task Manager says that the process is still running.

But, should it be taking this long?

childofthe1980s

Reply With Quote
  #3  
Old   
Rick Byham, MSFT
 
Posts: n/a

Default Re: SQL 2005 Upgrade Taking a Long Time - 08-13-2009 , 10:36 AM



2000 to 2005 is a pretty significant upgrade. The storage format changed so
it has to touch a lot (maybe all) of the data pages.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Linchi Shea" <LinchiShea (AT) discussions (DOT) microsoft.com> wrote

Quote:
It's hard to tell whether 30 minutes are too long. I've seen upgrades
taking
longer than that.

Linchi

"childofthe1980s" wrote:

Hello:

I am upgrading from SQL 2000 SP4 to SQL 2005. The upgrade of database
services is taking a long time.

The progress bar at the bottom is only on the 6th "block", and it has
been
there for over 30 minutes.

Granted the databases are fairly large. One is over 4GB. There are
about
18 databases. And, Task Manager says that the process is still running.

But, should it be taking this long?

childofthe1980s

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.