Solved

SQL express 2005 to SQL Express 2008

Posted on 2013-01-09
6
546 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
  • 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…

830 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