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

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

Upgrading clustered environment from sql 2005 to 2008

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



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.




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!

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

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


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!

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 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.

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: 

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...

Convert 2005 RDLC to 2008 using VS2010


Hi and thanks.


I'm getting an error on serveral reports that I built  in VWD2005 (express) using the reportviewer control.  Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok.  When I build the site, I get this error (and of course also when the report is ran):


Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1 


Here is my web.config concerning the RDLC assemblies, etc.

			<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
		<compilation debug="true">
				<add assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="Microsof

Applying SQL 2008 SP1 CU 2 in MOSS environment


Hi all,

I have a dedicated SQL 2008 x64 std edtion with SP1  for MOSS 2007 SP2, I would like to apply the CU2 for activating the lock memory page feature, I would like to know if there any incidence on the sharepoint farm after applying this CU on my SQL server?

Thank you for your feedback about that.




VS 2005 to 2008


Hi folks

Am in the process learning C#, My instructor uses Visual C# 2005 Express and on my side I have Visual Studio 2008 Pro.

Do you think it will affect me in my Coding practice due to the different IDE Versions? Wha do I have to heed when coding?



Upgrading VS 2003 Project File to VB Express Edition 2005



I downloaded some project from some site which is made in VS 2003. When I open its project file in Notepad I get following at first line Microsoft Visual Studio Solution File, Format Version 8.00. I don't have VS 2003 in my PC but I have VB 2005 and 2008 Express Edition. Now I wanted to upgrade that file but it is not doing. Can somebody help to upgrade it.

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