[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Upgrading to SQL Server 2008

Posted on 2009-07-02
11
Medium Priority
?
240 Views
Last Modified: 2012-05-07
We are upgrading to SQL Server 2008 from SQL Server 2005. We are running SQL Server Reporting Services 2005 as well. Please suggest any good sources/links to upgrade articles. Also, if anyone has experience upgrading SQL Server, anything we should watch out for? I heard that the reports we have created with SQL Server 2005 will not function after the upgrade??

We built our previous reports using SQL Management Studio/Visual Studio 2005. Anything difficult about this upgrade? How long did it take?
0
Comment
Question by:pzozulka
[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
  • 5
  • 3
  • 3
11 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24767120
>> I heard that the reports we have created with SQL Server 2005 will not function after the upgrade??

Its not the case. SQL Server 2008 SSRS was designed such that it wont break the existing functionality and provide more functionalities.
Hence reports created in 2005 will work in 2008

For the upgradation path, this should help you out:

http://msdn.microsoft.com/en-us/library/ms144267.aspx
http://msdn.microsoft.com/en-us/library/bb677622.aspx

Some considerations or pre-requisites for upgradation
http://technet.microsoft.com/en-us/library/ms143747.aspx

Hope this helps
0
 
LVL 8

Author Comment

by:pzozulka
ID: 24767157
Thank you for your links. I have found some very troubling news. We want to upgrade to SQL Server 2008 Standard Edition, but right now we have SQL Server 2005 Enterprise Edition. According to this article http://msdn.microsoft.com/en-us/library/ms143393.aspx it is not supported.

What can I do?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24769301
I suggest you to take full backup of all your databases and install fresh copy of your SQL Server 2008 and restore your databases, I guess that is the only option remain for you now.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 1000 total points
ID: 24769682
Since editions are not mentioned in the question, mentioned that generic approach.
And so you cannot proceed with those steps now.

As RiteshShah mentioned above,
1. You need to do a complete backup of your databases
2. Take Backup of your system and msdb database too.
3. Take Backup of your Logins.
4. Uninstall SQL Server 2005 Enterprise
5. Install SQL Server 2008 Enterprise
6. Restore your Backups
7. Run the Login Scripts.
0
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 1000 total points
ID: 24770181
minor correction in above steps:

1. You need to do a complete backup of your databases
2. Take Backup of your system and msdb database too.
3. Take Backup of your Logins. (database backup and system database backup will do)
4. Uninstall SQL Server 2005 Enterprise
5. Install SQL Server 2008 Enterprise (should be standard, if it was enterprise, could be able upgrade directly)
6. Restore your Backups
7. Run the Login Script
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24770189
moreover, if you wish, don't uninstall SQL Server 2005 until you successfully run SQL Server 2008 with restored database, you can run two different version of SQL Server with named instance, however this is not necessary

0
 
LVL 8

Author Comment

by:pzozulka
ID: 24770236
OK to install SQL Server 2008 Standard on the same server as SQL Server 2005 Enterprise?

Backup 2005 DB and Logins, and restore to 2008? Correct?

Also, not sure what you guys mean by "Run Login Script?"
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24770242
you will not need it I guess, once you will restore Master database and then all your databases, it will do the job.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24770598
RiteshShah,
    It was correct. Taking Login Backup is not required if we take backup of maser database.
Thanks for correcting me out.
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24770605
It's ok rrjegan, it happens sometime when we answer in hurry.... not a big issue, I am 100% sure it was just a minor slippages.

0
 
LVL 8

Author Comment

by:pzozulka
ID: 24809529
One more question, what about SQL Reporting Services. When I backup and restore to SQL Server 2008, what will happen to the Reporting Server, how will that get upgraded?
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

656 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