.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Upgrading from 2005 to 2008 (R2?) What ar eadvantages for small business ?

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :Sql Server

I'm looking at upgrading some ( 13 including my DR site ) servers from 2005 to 2008 or 2008 R2.  I don't work for a huge shop ( in terms of SQL installations ).  I support primarily 3rd party applications on the servers, an increasing number of in-house applications.  I do have each server configured to do log shipping to a DR site via LiteSpeed logshipping - so the log shipping is really my only "different" factor.

I've verified with my 3rd party vendors that they ( almost ) all support 2008 R2 now - waiting on 1 more.

I'm just wondering - are there "smaller business" reasons to utilize the R2 release?  It looks to me like it's focussed more on larger scale installations.  Are there any significent performance enhancements in the engine that make it a more attractive upgrade than the initial 2008 release?

I'd welcome your input!

View Complete Post

More Related Resource Links

Upgrading from sql 2005 to sql 2008

I have a general question: I'm upgrading from sql 2005 SP 2 x64 on Windows 2003 R2 SP2 to sql 2008 SP1. Disks are directly attached, (no SAN).  Can I detach my user databases first, run the upgrade, then re-attach?  Is it faster that way? Are there any dangers in doing that?  Also, you'd think it would make recovering from a failed upgrade easier since they reside on a separate drive and will still be 2005 database files.  I could re-install sql 2005 and re-attach them since they never were touched by the upgrade.

upgrading to sql 2008 x64 from sql 2005 x86

Over the next couple of days I need to preform a sql server upgrade on our Dynamics server and normally this wouldn't be a problem but I am currently running 32 bit sql 2005 on the machine that I plan to install sql 2008 64 bit standard edition onto. Can I do an "in place upgrade" over the existing installation? It is the default installation (MSSQLSERVER). I wasn't sure if this would be possible for me to do or not since I am doing the 32/64 bit jump. Or do I need to uninstall sql 2005 from the machine entirely and then put on 2008? I am hoping someone has been down this road before because I'm trying to plan out the quickest path to get this accomplished. Thanks in advance for any help!

SS2008 Supported on Windows Server 2008 Small Business

I am planning to install Sql Server 2008 x64 on Windows Server 2008 x64. My question : Is it only SqlServer2008 Standard Edition x32 supported on SBS2008? I checked the chart of the SW requirements and I am not sure about it.

Cannot Browse cube correctly after upgrading SQL Server 2005 to SQL Server 2008


I upgraded to SQL Server 2008 from 2005 and now when browsing my cubes only one measure displays at a time e.g. i can view two measures actual month and YTD the two displays but when i drag a dimension to the row, the actual month disappears and only YTD displays. if i remove the YTD measure the actual month shows again. Without the dimensions in the rows they both show. Does anybody have a suggestion on how to resolve this? it worked perfectly well before the upgrade.


upgrading sql server 2005 to sql server 2008

how can i upgrade my database server from sql 2005 to sql 2008 ....& how can i transfer my data of sql 2005 to 2008. is there any change which i need to do in the Visual c# application to connect to database or the Connection string remains the same.....
| http://geekswithblogs.net/akshaylamba/ | Student , XI Akshay Deep Lamba

Do I remove the reference System.Web.Extensions when upgrading from VS 2005 to VS 2008?


I've got an old ASP.NET 2.0 app, which I added the AJAX Toolkit to, later in development.  When I did that I had to include the System.Web.Extensions.dll in the bin folder of the ASP.NET app, in order for it to work.  Naturally I then included a reference to that assembly DLL into the project, and pointed to it for each page I used it in.

Now I want to upgrade the app to VS 2008.  When I did it looks to me as though it added another reference to System.Web.Extensions from the GAC.  Now VS 2008 is confused and wants me to remove one of them.  The question is, which one do I remove? 

Upgrading clustered environment from sql 2005 to 2008




Can any one give me the best approach to upgrade a 4 node (a/a/a/p) clustered environment from sql 2005 on win server 2003  to sql 2008 on win server 2008 with minimum downtime.




Microsoft SQL Server 2008 Standard Edition for Small Business supports Windows 7 Pro ?


Microsoft SQL Server 2008 Standard Edition for Small Business supports Windows 7 Pro ?

I have try to install its failed at Rule check is their any work around?

many thanks



SQL SVR 2008 Small Business failed at Windows 7 x64 bit


Dear Friend,

When i try to install  SQL SVR 2008 Small Business failed at Windows 7 x64 bit  at EditionRequirementCheck (Rule)


Checks whether the SQL Server edition is supported on this operating system.


Upgrading from SQL server 2005 to 2008 and get an error message

I am halfway through the process and get this error message "Use the Reporting Services Configuration tool to configure the database source name (DSN) and connect to the database." on the Reporting Services Authenication page.

This is the runtime version that is distributed with Amicus Attorney, a lawofffice management program.

I can barely spell SQL and have no idea what this is about, but Amicus told me it wasn't their issue.

cannot install Microsoft SQL Server 2008 Standard Edition for Small Business

im trying to install this on MS windows Server 2008 R2 STD ED.  is says on the installation " Operating system supported for this edition " ( failed ). is it not compatible with my O.S. thank you.

Upgrading SQL Server 2005 to 2008 R2



We are planning to upgrade our sql server 2005 environment to sql server 2008r2 please tell me how to do?

This is the existing setup:

1. Window Server 2003 64 bit Enterprise Edition With SQL Server 2005 64 Bit Enterprise Edition With SP2

2. 2-Node Clustering (Active/Passive)

3.Transactional replication

4.Linked Servers (Connected to 2 other servers with same configuration)




Error on upgrading from SQL Server 2005 to 2008 R2 from version 628 to version 629

We having dificulties in restoring a SQL Server backup from 2005(x86) to 2008 R2(x64). We used a typical backup/restore combination to a file. After importing data (aprox. 90GB), it gets to 100%, and then an error appears:

8631 - Internal error: Server stack limit has been reached. Please look for potentially deep nesting in your query, and try to simplify it.

We think the problem is related to a problem in one of the upgrade steps:

This is the output:
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 11289048 pages for database 'My_Database', file 'FILE_Data' on file 1.
Processed 188 pages for database 'My_Database', file 'FILE_Log' on file 1.

Converting database 'My_Database' from version 611 to the current version 661.
Database 'My_Database' running the upgrade step from version 611 to version 621.
Database 'My_Database' running the upgrade step from version 621 to version 622.
Database 'My_Database' running the upgrade step from version 622 to version 625.
Database 'My_Database' running the upgrade step from version 625 to version 626.

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

VSTO 3.0: Developing Office Business Apps with Visual Studio 2008


With custom form regions in Outlook you can pull in data from designated data sources and truly customize your users' Outlook 2007 experience.

Steve Fox

MSDN Magazine Launch 2008

Converting Crystal Report 2005 to 2008 - Please Tell Me I'm Stupid :)


Hello peeps,

  I have a series of Crystal Reports that I can view/edit using Visual Studio 2005 with no issues.  The method I'm using is to simply click on the *.rpt file and it opens in the VS crystal editor with no issues.  The problem I'm having is that we are upgrading to Visual Studio 2008, and when I open the *.rpt file in 2008 it opens as a binary file.  I guess I'm used to everything else in Visual Studio prompting me to convert the older version to the newer version, so I'm not sure what to do in this case.

  Is this normal?  Is there an easy conversion method that I'm simply overlooking?  Am I screwed?  Who invented liquid soap, and why?

Answers to any of these questions would be greatly appreciated...

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend