Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / March 2006

Tip: Looking for answers? Try searching our database.

Upgrade to sql 2005

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mecn - 27 Mar 2006 18:34 GMT
Hi,

I have a new cluster server not sure whether I should install sql 2k or sql
2005.
I need to move all prodcution dbs from regular sql2k server to the cluster
box.
What is the best way to move?
Install sql2k first move all dbs including sys dbs and then upgrade to sql
2005.
This will save me a lot of works ---sql jobs. Is this possible?

My second question is that After I upgrade the cluster to sql 2005. Can I
still do the log shipping from regual sql2k to this cluster sql2005?

Thanks,.
mecn - 27 Mar 2006 18:50 GMT
Is it very difficult to update from sql2k to sql2005 in cluster box without
SAN.
If not what should I be aware of during the upgrade process.

Thanks,

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks,.
Geoff N. Hiten - 27 Mar 2006 19:38 GMT
Going from a stand-alone SQL 2000 environment to a clustered SQL 2005
environment is a big step.  I would hesitate to do both steps at once, and I
have had a lot of practice at version upgrades and cluster installations.  I
also don't like upgrades, especially on a cluster.  I strongly prefer
systems built with only the current versions.  Also, there have been some
reports of difficulties with the cluster upgrade process for SQL 2005.  I am
reluctant to recommend it until I can do some more testing.

In theory, you can log ship from SQL 2000 to SQL 2005, but I would set up a
test environment and make sure.  You will have to use your own scripts to
manage log shipping, neither of the built-in versions will work.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks,.
mecn - 27 Mar 2006 20:22 GMT
Thanks, Geoff.

> Going from a stand-alone SQL 2000 environment to a clustered SQL 2005
> environment is a big step.  I would hesitate to do both steps at once, and
[quoted text clipped - 24 lines]
>>
>> Thanks,.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.