Solved

Upgrading to sql server 2005

Posted on 2008-06-13
3
209 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: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

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 …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

829 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