Upgrading a Database SQL 2000 to SQL 2005

Question

Post reply

Upgrading a Database SQL 2000 to SQL 2005

Sachin Samuel-286731

Right there with Babe

Points: 778
More actions
May 3, 2007 at 11:45 am

#177788

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/ssamuel/2987.asp

Viewing 15 posts - 1 through 15 (of 35 total)

You must be logged in to reply to this topic. Login to reply

Gaurav Kohli-415349 Grasshopper Points: 19 More actions · Answer 1

Perfect article..... Simple and easy to understand even for someone like me with little or no idea about SQL

Good Going Sachin

GK

Deepa V Valued Member Points: 72 More actions · Answer 2

Excellent Article! Step by step details with snapshot that makes it easy for the first time user. Including all the details.

Keep it up!

Deepa

Mark Lar SSC Enthusiast Points: 122 More actions · Answer 3

We carried out an inplace upgrade and the database works fine, BUT, when we run the Surface Area Configurator the database is not found! Any ideas please?

Thanks

M

Sachin Samuel-286731 Right there with Babe Points: 778 More actions · Answer 4

Hi Mark,

Surface area never displays your database. But the services installed on your box. It provides interface for enabling or disabling many Database Engine, Analysis Services, and Reporting Services features. Disabling unused features helps to secure your Microsoft SQL Server installations by reducing the SQL Server surface area.

Hope I answered your query.

Regards

Sachin

Mark Lar SSC Enthusiast Points: 122 More actions · Answer 5

Thanks Sachin

Sorry maybe I did not make myself quite clear. The surface area configurator does not find my sqlserver service, so I am unable to configure the service particularly email notifications.

How can I get it to find my sqlserver service?

Thanks

M

Sachin Samuel-286731 Right there with Babe Points: 778 More actions · Answer 6

Mark,

On clicking Surface area configuration link, a small window appears with the following links

1) Surface Area configuration for Service and connections.

2) Surface Area configuration for features.

Seems like you clicking only on second link to check for the services.

You can manage Sql Server 2005 services as well as remote connections from the first link.

Please let me know incase you have any query or need further clarifications.

Best Regards

Sachin

Mark Lar SSC Enthusiast Points: 122 More actions · Answer 7

Sachin

No, I can only see my BackupExec service and not my SQL2005 service via option 1!!

Any ideas?

Thanks.

Mark

Sachin Samuel-286731 Right there with Babe Points: 778 More actions · Answer 8

Mark,

Which Edition of SQL server 2005, you have upgraded to?

Regards

Sachin

Mark Lar SSC Enthusiast Points: 122 More actions · Answer 9

Mark Lar

SSC Enthusiast

Points: 122

May 16, 2007 at 5:36 am

#706733

Hi

Standard Edition + latest service pack.

Thanks

SRDEV SSC Enthusiast Points: 101 More actions · Answer 10

This article certainly highlights the difficulty of performing quality technology services when basic communications skills are substandard. This article is a difficult read, not for the technical content, but for the grammatical errors, poor sentence structure and even spelling mistakes. While the author's technical skills may be adequate, writing such an article to build a reputation, gain clients and impress others may have a very different effect. Such an article should demonstrate a certain skill level in two areas, technology and communications. This author has one. We should, and this board should, strive for excellence in both.

mamta patni Grasshopper Points: 11 More actions · Answer 11

Nicely written article, gives a fair idea about SQL database upgrade.

keep it up !!

Mamta

Lee Davis-285380 SSC Enthusiast Points: 146 More actions · Answer 12

The article is complete and it asissted me in doing the upgrade. I've asked my fellow consultants in my company to consider this article as the best practices for our team.

Thanks for the hardwork that was necessary to create this article!!

Carlos Sepulveda Grasshopper Points: 22 More actions · Answer 13

Besides Sachin's guide, I'm also reviewing book "Microsoft SQL Server 2005 Unleashed" (SAMS pub) for the proper upgrade path, and find the information about Fulltext indexes conflicting.

While Sachin states Fulltext indexes should be completely removed before upgrading and recreated, the Unleashed text states these are taken care of in both Side-by-Side and In-Place upgrades:

From page 208 for Side-by_Side: "You might be wondering how the [Copy Database] wizard handles your full-text catalogs. Rest assured, they are imported by default during either a restore, an attach, or via the Copy Database Wizard..."

From page 217 for In-Place: "...When your upgrade of the database engine is complete, it is recommended that you perform the following on all databases (also recommended for side-by-side migration): -Repopulate your full-text catalogs. (This is automatically done for databases where Full-Text indexing was enabled prior to the upgrade.)..."

I did not find any reference in the Unleashed text about removing the full-text indexes prior upgrading at all.

What gives???

Thanks for your replies. Great article by the way.

Charlie S.

Dinesh-455184 Grasshopper Points: 11 More actions · Answer 14

Article is well structured, concise and to the point. It reflects a competency level of an author in this topic. I find it interesting and easy to digest inspite of a fact that the database upgradation has never been my cup of tea.

I really wonder what would happens to a pre-compiled stored procedures which have been created by a user? Would there be any impact on those stored procedures ?

Keep writing more stuff (:-

Regards

Dinesh