Solved

SQL 2000 instance upgrade to 2005

Posted on 2011-02-15
4
333 Views
Last Modified: 2012-05-11
I have a server running an instance of SQL 2000 and I wish to upgrade this to SQL 2005. I can find loads of information regarding importing databases etc but I wish to simple upgrade the software so that I don't lose all the SQL user info, permissions and settings.

Thanks
John
0
Comment
Question by:inventiveIT
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Kalpesh Chhatrala
Comment Utility
0
 
LVL 16

Expert Comment

by:Kalpesh Chhatrala
Comment Utility
0
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
Comment Utility
hi

bassically 9 out of 10 times a simple upgrade will work for you.
just slid the dvd in and run the sql server installer.

i would recommend just before you upgrade use the "Sql Server Upgrade Advisor"
to learn about possible problems and issued your current system could have with the upgrade.

BTW: the sql server upgrade advisor is on the install dvd .
0
 
LVL 9

Expert Comment

by:shalabhsharma
Comment Utility
Yes I agreed with ashilo  "Sql Server Upgrade Advisor" is the best way you should do.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now