Solved

Upgrading to sql server 2005

Posted on 2008-06-13
3
210 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Select - Finding chars in a column 2 72
SQL Encryption question 2 66
Not selecting duplicate data 6 66
Can I skip a node in XML? 9 36
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

697 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