Solved

Upgrading to sql server 2005

Posted on 2008-06-13
3
206 Views
Last Modified: 2010-04-21
Hello Experts! Iam updrading from sql server 2000 std edi sp3  to sql server 2005 sp2. Basically to a new Server(box) because present it is 2000 advanced server planning to get new box i.e 2003 edition.

can you tell me basic steps...Thanks
0
Comment
Question by:Sandeepiii
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
rickchild earned 500 total points
ID: 21778011
See the information here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

If you are moving box you won't be able to do the "In-Place" upgrade so easily which maintains all your user logins.  You will be doing a "side-by-side" migration.

You are looking more at installing SQL2005 on the new box
Backing up & Restoring the databases to the new box.

If you are working with large data sets then also consider the 64bit Versions, as this has much improved memory management and limits.
0
 
LVL 13

Assisted Solution

by:rickchild
rickchild earned 500 total points
ID: 21778031
Information on transferring Logins to the new server:

http://support.microsoft.com/kb/246133
0
 

Author Closing Comment

by:Sandeepiii
ID: 31466887
Yes solution is complete.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to DELETE multiple rows of data for a SINGLE RECORD based on coded DATE field that is found within ONE of the Rows? 9 57
SQL Query 2 61
Grid querry results 41 78
Sql query 107 60
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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