.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

Update MS SQL 2008 R2 with SP2

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

I trying to install SP2 on my SQL 2008 R2 but it dont find anything to uppdate.

Running it on a Windows Server 2008 R2. Using this file: "SQLServer2008SP2-KB2285068-x64-ENU.exe"

Is there anything I doing wrong or does it just dont work for R2 version?

View Complete Post

More Related Resource Links

Transferring data (on update) from SQL to SLQL (2008

Hi there,   we are having 2 MS SQL 2008 servers, where the first one is our main machine where our ERP (Navision) is running on. Now, due to a customer request, I need to send data from our main sql server into our second sql server. But not everything, only some specific datasets (only if the specific customer is affected)... not only on inserts, but also on updates and on multiple tables.   I am not quite sure which technology to use for that, I tried to read something about Integration Services and Trigger, but as I am not really into both of them and not sure what technique would be the most suitable, I'd like to ask the experts here for some advice.   The affected rows might be around 2-10% of our total inserts / updates a day.   Any help would be appreciated!

MSAS 2005 vs 2008 - different results of an UPDATE CUBE instruction

Hi ALL!   When moving from SSAS2005 to SSAS2008 I have a problem with write enabled cubes. On SSAS2005 UPDATE CUBE instruction occures almost instantaneously but on SSAS 2008 this takes few seconds. I created a cube with one dimension and one measure for testing. No aggregations, fact table initially empty, measure has 3 elements. Profiler shows that SSAS2008 UPDATE CUBE instruction initiates cube processing, but SSAS2005 doesn’t do this. What's wrong? Please, help! SSAS2005 Profiler: http://savepic.ru/1593644.jpg SSAS2008 Profiler: http://savepic.ru/1584428.jpg   Thnx!

Cumulative Update CU4 For SSRS 2008

trying to download CU4 For SSRS 2008 SP1, I'm confused as to what the different suffixes mean at the end of the CU name, I seeRRB2ClickOnSNACRSSharepoinCan someone explain to me what these are or what the differences are?  SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_CU_Updated_Ref_KB_976761 2008 10.00.2740.00 237625057 11/4/2009 7:06:28 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RRB2ClickOn 2008 10.00.2734.00 122189228 9/22/2009 4:18:56 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4 2008 10.00.2734.00 237547729 9/22/2009 7:13:01 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumulative_Update_4_SNAC 2008 10.00.2734.00 7012764 9/22/2009 7:23:53 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RSSharepoin

update sql 2008 with rows in sql 2000

Hi All, Currently I have data being inserted / updated on sql 2000. I want to update sql 2008 up to the minute. So I need to check and update sql 2008 with insert / update or delete occurred in sql 2000. My question is how to do it? I do not have timestamp column in any table. So do I need to add timestamp datatype column? If I do, then how do I keep track of starting and end value? Thanks in advance.  

SQL*Server 2008 SP1 applied but still tries to download and install from Windows Update

I had previously posted this on the windows update forum and was advised here was more appropriate. I have installed SQL*Server Express 2008 on laptop with windows7 and appled the SP1 update. This shows as applied correctly when looking at programs/updates from control panel, update logs. The management console confirms version 10.1.2531 is running. Each time I use windows update  the service pack is listed as needing download / install - the same KB968369 is given as the reference. I have run this a couple of times but the update is shown as outstanding each time. Any ideas how to resolve this? Thanks Colin

Problem installing Cumulative Update 6 for SQL 2008 SP1 on Windows XP

I am attempting to apply SQL Server 20008 SP1 Cumulative Update 6 on my Windows XP desktop. The update executable is unpacked and I get a brief flash of a Command Screen and then nothing. I have searched for any update files but have not found any. My Desktop Configuration: Windows XP SP3, Windows Installer 4. SQL Server 2008 SP1 Developer Edition. I am also attempting to install the Client Tools for SQL 2008R2 on this same desktop and am getting the same results. I click on SETUP and get a brief flash of the Command Screen and the installation does not continue. Internet searches speak of a problem with a registry entry in the Boostrap Key for a valid Setup directory, but this key exists in my desktop registry. Thanks,

Cumulative Update 5 - wrong SQL 2008 version number


Hi all,

I installed Service Pack 1 for SQL 2008 on one of my servers. This server has multiple instances. In this case, it is the instance "SHAREPOINT2010" that is giving me difficulties.

For Sharepoint 2010, we need to install cumulative update 5. This update fails due to the fact I do not have the correct SQL version. It is expecting version 10.0.2531 (SP1), but it says I have the 10.0.1600 (RTM). When I check in my management studio and via the @@version, I do see the confirmation I have version 10.0.2531. (also see attached screenshot).

Does anyone know why the cumulative update fails to see the correct server version ? If I try to install it on another SQL 2008 SP1, it works fine..;

Thank you !



screenshot sql version

Removing SQL 2008 R2 Cumulative Update 3


Cumulative Update 3 completely destroyed my SQL 2008 R2 installation.  We were hoping it resolved some of the issue we are seeing with R2 but unfortunately now SQL will not start.  Is there any way to completely remove cumulative update 3 from the server?  We are running SQL 2008 R2 on Server 2008 r2 x64. 

Any insight will be greatly appreciated. 



Cannot download Cumulative update package 2 for SQL Server 2008 !


Hi all,


I currently need to install Cumulative update package 2 for SQL Server 2008 service pack 1.

It is located at :


When i click on View and request hotfix downloads it has the following error :

Unfortunately it says "The system is currently unavailable. Please try back later"


Where can i fin this package ?


I need to install this to finish off the installation of Sharepoint 2010.


SQL Server 2008 offline while installing Cumulative update


I've been asked to install SQL 2008 CU 10 for SP1 and was wondering if the sql server is still available during the install of the cumulative update.  Is a restart necessary after installing a cumulative update?  I don't have a test machine and I need to apply it to a production server.


SQL Server 2008 R2 Report builder - Cannot update a list of fields for the Query



I have existing report connected to SSAS cube. When I try to change the query and click OK, i get this message "Could not update a list of fields for the query. Verify that you can connect to the data source and  your query syntax is correct"

My Query syntax and access to data source dont have any problem.  Because fo this issue, i cannot update the query used in the report. How do i resolved this issue?



2008 SP1 update error


Hi All,

I have run into an issue while installing 2008 SP1. Here is the background info:


Upgraded SQL 2000 SP4 Enterprise  to 2008 Enterprise. System is a publisher/distributor in a merge replication schema.

Upgrade went ok, replication is working. Replication Monitor is not working due to a known bug (which is resolved by SP1 and a hotfix patch).

Anyhow after SP1 installation server fails to start due to a corrupted master database. The below log should show why the master gets corrupted:



2010-10-25 20:35:54.27 spid7s   Database 'master' is upgrading script 'msdb_upgrade_discovery.sql' from level 167773760 to level 167774691.
2010-10-25 20:35:54.27 spid7s    
2010-10-25 20:35:54.27 spid7s   ----------------------------------------------------------------
2010-10-25 20:35:54.27 spid7s   msdb_upgrade_discovery starting
2010-10-25 20:35:54.91 spid7s   MSDB format is: SQL Server 2008
2010-10-25 20:35:54.98 spid7s   User 'sa' is changing database script level entry 4 to a value of 2.
2010-10-25 20:35:54.98 spid7s   User 'sa' is changing database script level entry 5 to a value of 2.
2010-10-25 20:35:54.98 spid7s   User 'sa' is changing database script level entry 6 to a value of 2.

SQL 2008:Peer 2 Peer Replication: Update-Update Conflict on the same node


My environment is comprising of 2 SQL servers setup with P2P replication in SQL 2008, 2 Web servers connect to only one SQL server at a time and make changes to the published tables and 2 Application servers which connects to both the SQL servers all the time but they only read data.

We chose P2P since my app servers are in different locations which read data from both the SQL servers and we use it as HA solution.

Since we are changing data at only one SQL server, thought we should never get update-update conflicts but we are now on the same node.

A conflict of type 'Update-Update' was detected at peer 3 between peer 1 (incoming), transaction id 0x0000000000725ca2 and peer 1 (on disk), transaction id 0x00000000007259e9 (Source: MSSQLServer, Error number: 22815)

We are making changes only at Server A and Server B is my backup server.

I made a varchar field updated in 1 row on a table in server A then it gets replicated to Server B
then I made the same field updated for 160 rows on the same table in Server A then it gets replicated to Server B
then I reverted back the change made to the field on all 160 rows on the same table in Server A then my replication failing with Update-Update conflict.

I'm not sure whats causing this because I'm not making any change

Windows Update Error - Win XP, Win 7 and Server 2008


We have a mix of Windows XP and 7 PC and Windows 2008 servers that are configured to use our WSUS update server.  However, we have begun to notice that most of the PCs aren't consistantly communicating with the WSUS server. Also, if we try to run the Windows update process on the PC or other Server, we get the following error message:

Code 80244021 - Windows Update encountered an unknown error.

Review of the WEB only shows problems for Vista PCs and the suggestions to resolve the error doesn't work any way.

Chris Premo

cumulative update 4 for 2008 R2


Has anyone succeeded in downloading this in the last week?  Whenever I click on the link to request a hotfix (i.e. download the update), it says "try back later":


Thank you.

SQL update from 2008 Standar to 2008R2 Enterprise crashed SQL Agent


Hello, yesterday I updated my SQL server from 2008 x64 Standard to 2008R2 x64 Enterprise.

The first update give me some errors but the install dont stop, at the end it shows a message asking for a repair action from Control panel -> Programs. I made a repair and all service were repaired except reports, not important for beacuse I dont use it, at least for now.

After that, SQL server service starts ok, but SQL agent show a message that says its disabled.

If I try to run from console I get this error message:

Microsoft (R) SQLServerAgent 10.50.1600.1
Copyright (C) Microsoft Corporation.

No se pudo ejecutar StartServiceCtrlDispatcher (error 6).

I look at registry and paths appears to be ok.

I try to change the user that runs the agent, (changing permissions too) but nothing changes.


My last option is backup, deinstall, ccleaner to remove possible registry entries from SQL and make a clean install and restore backups, but with agent disabled, backups dont work.

¿Any idea about how to enable the sql server agent or how to backup databases and restore to a clean install?


SQL Server 2008 R2 Standard edition License update (Developer license to Production License)


We have an MSDN copy of the SQL server 2008 R2 standard edition which we have installed in production environment. We have subsequently bought a licensed copy of MS SQL server 2008 r2 Standard edition. Using the feature Maintenance and Edition Upgrade in SQL setup, we have updated the licensed product key information of the SQL server 2008 R2 from licensed setup file in production environment. We wanted to know how to view the licensed product key information from the server. Also we wanted to check if we have completed the process and we are legally using the software

Query: select serverproperty('LicenseType'),serverproperty('NumLicenses') Is always returning “Disabled” and “NULL” before and after using Edition upgrade with valid license details.


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