Solved

Upgrading to sql server 2005

Posted on 2008-06-13
3
205 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query help 7 96
Change variables in SQL table 6 81
2 comma seperated list - SQL Server 12 37
ms sql + top 1 for each customer 3 43
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
A short film showing how OnPage and Connectwise integration works.

914 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

21 Experts available now in Live!

Get 1:1 Help Now