Solved

SQL express 2005 to SQL Express 2008

Posted on 2013-01-09
6
553 Views
Last Modified: 2013-01-11
trying to fix a mess.

I have a windows 2008 r2 64x box with WSUS and Trackit that are using SQL express 2005 for the database manager. yes i know this is not supported. I know nothing about sql so you will have to walk me through this if possible.

what i want to do. install SQL Express 2008 on same Server and move/upgrade the databases to 2008 and remove 2005. sounds simple enough but i know nothing about sql.

is it possible. do you need more info? the trackit program only supports sql to version 2008 so going to 2010 or 2012 is not an option.

Thanks

Corey
0
Comment
Question by:Coreyg13
[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
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38761472
>>only supports sql to version 2008 so going to 2010 or 2012 is not an option. <<
There is no SQL Server 2010.  

Do you want to install the Express Edition of SQL Server 2008 or SQL Server 2008-R2?
Are you installing it on a new server or the same one as the SQL Server 2005?
0
 
LVL 2

Author Comment

by:Coreyg13
ID: 38761483
Yes the express version of 2008 r2 and yes install to same server.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38761584
Then it should be as simple as doing an in-place upgrade as it appears that this route (SQL Server 2005 to SQL Server 2008-R2) is supported.  See here:
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 38761775
Just run the SQL Server installer and  check the option "Upgrade from SQL Server 2000/2005/2008"

and follow the steps.
0
 
LVL 2

Author Comment

by:Coreyg13
ID: 38762836
So I ran the install and chose the upgrade option and got an error message. i was able to install a new instance of 2008 r2 though. is there a way to move the databases to the 2008 instance and upgrade the databases?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 38765620
i was able to install a new instance of 2008 r2 though. is there a way to move the databases to the 2008 instance and upgrade the databases?
Restore the SQL backups from the old instance in the new instance.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

635 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