Search results matching tag 'Service Pack 1'

March 2013 Cumulative Updates - SQL Server 2012 SP1 & 2008 SP3

AaronBertrand — Mon, 18 Mar 2013 21:40:00 GMT

SQL Server 2012 Service Pack 1 Cumulative Update #3

Build # 11.0.3349
KB Article: KB #2812412
38 fixes!
Relevant for builds 11.0.3000 -> 11.0.3348
NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999)

SQL Server 2008 Service Pack 3 Cumulative Update #10

Build # 10.00.5835
KB Article: KB #2814783
8 fixes
Relevant for builds 10.00.5500 -> 10.00.5834
NOT for SQL Server 2008 R2 (10.50.xxxx)

SQL Server 2012 Service Pack 1 Cumulative Update #2 is available!

AaronBertrand — Thu, 24 Jan 2013 18:42:00 GMT

The SQL Server team has released CU #2 for Service Pack 1, which should include all of the fixes from CU #5, as well as some others.

KB article: KB #2790947
Build # is 11.0.3339
This build has FIFTY fixes!

There is also a KB article (KB #2792921) describing a couple of new features delivered with this cumulative update: enhancements to sysprep, and the ability to backup directly to Windows Azure Blob storage.

Relevant for builds 11.0.3000 -> 11.0.3338. Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any previous version.

SQL Server 2012 Service Pack 1 Cumulative Update #1 is available!

AaronBertrand — Tue, 20 Nov 2012 20:17:00 GMT

Waited to deploy SQL Server 2012 until Service Pack 1 was released? Then held off because Service Pack 1 did not include important updates from Cumulative Update #3 and Cumulative Update #4? You're running out of reasons to procrastinate! The SQL Server team has released CU #1 for Service Pack 1, which should include all of the fixes from CU #3 & CU #4, as well as some others.

KB article: KB #2765331
Build # is 11.0.3321
I count a whopping 44 fixes!

Relevant for builds 11.0.3000 -> 11.0.3320. Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any previous version.

SQL Server 2012 Service Pack 1 is available - this time for sure!

AaronBertrand — Thu, 15 Nov 2012 18:21:00 GMT

Last week I mentioned in passing that Service Pack 1 is now available, while I was blogging from the PASS Summit keynote. I wanted to put up an official post instead of having it appear as a footnote there (I also updated my April Fools' joke to point to the right place).

Service Pack 1 Details

Service Pack 1 is build # 11.0.3000 and includes 13 fixes to public KB items and 35 other internal (VSTS) items. You can see the list of fixes in KB #2674319.

You can also read about new features included in SP1 (well, first included in SP1 CTP4) on the Analysis Services team blog or in Books Online on MSDN.

You can download Service Pack 1 from the following URL:

http://www.microsoft.com/en-us/download/details.aspx?id=35575

A Caveat for Slipstreamers

The download page currently offers slipstreamed ISOs. However, another knowledge base article claims that, at least at the time of writing, these ISOs do not work. See more info in KB #2783963 - but for now I would suggest just downloading the standard SP1 installer (SQLServer2012SP1-KB2674319-x64-ENU.exe or SQLServer2012SP1-KB2674319-x86-ENU.exe). I haven't tested it, but you should still be able to build your own slipstream installs by combining these standard installers with your existing images, the "old-fashioned way."

Fixes from Cumulative Updates

Due to the length of time that goes into testing a Service Pack, SP1 includes only the updates from Cumulative Update #1 (11.0.2316) and Cumulative Update #2 (11.0.2325). So if you are relying on updates from Cumulative Update #3 (11.0.2332) or Cumulative Update #4 (11.0.2383), you may want to hold off on Service Pack 1 until the first post-SP1 Cumulative Update is available. Typically this is advanced so that you're not waiting an entire Cumulative Update cycle (~8 weeks), so I would expect it well before the end of the year.

Feature Pack

The SQL Server 2012 SP1 Feature Pack downloads are also available:

http://www.microsoft.com/en-us/download/details.aspx?id=35580

SQL Server 2012 Express Edition Service Pack 1

If you are looking for Express SP1, general web searches will probably lead you through a bunch of registration brouhaha - here is a direct link:

http://www.microsoft.com/en-us/download/details.aspx?id=35579

The most interesting thing about the Express release, to me, is that now the full version of Management Studio is completely free. The Express download page says that it includes Management Studio Express, but I have installed this, and it actually installs Management Studio proper with none of the limitations you are used to. Obviously some of the features that didn't exist before still don't make sense when you're only managing an Express instance (e.g. SQL Server Agent), but now you can use the free version of Management Studio to fully and properly manage all editions. Other tools such as Profiler and the Database Engine Tuning Advisor are now included also.

SQL Server 2012 Service Pack 1 CTP4 is available

AaronBertrand — Thu, 20 Sep 2012 18:28:00 GMT

This morning the SQL Server team announced the release of Service Pack 1 CTP4 for SQL Server 2012. Back in July I talked about CTP3 and how the release contained BI features only; no fixes. The newer CTP does have fixes and other engine enhancements as well; there is even proper documentation in Books Online about the enhancements. The download page also lists them:

http://www.microsoft.com/en-us/download/details.aspx?id=34700

The build # is 11.0.2845. There are 37 fixes listed in the knowledge base article, KB #2674317 (but it's possible that number will change before RTM). Many of these fixes are ones that were included in RTM CU#1 and CU#2. No fixes from CU#3 are currently present in the SP1 CTP.

SQL Server 2012 Service Pack 1 CTP3 is available - but there's a catch

AaronBertrand — Tue, 24 Jul 2012 14:05:00 GMT

Back on July 5th, I somehow missed that the SQL Server team had published a Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1. This is the 3rd CTP (I guess I missed the first two as well, but more likely those were simply not made public). However, before you download it, there's a catch:

This early CTP3 version of the SP1 release is intended ONLY for those customers who are testing Business Intelligence capabilities available in Office 2013 and SharePoint 2013 public preview program. DO NOT install this early CTP3 release for general SQL Server 2012 patches and bug fixes.

According to Microsoft, the Service Pack CTP contains *none* of the fixes from Cumulative Update #1 and Cumulative Update #2, even though the build number is a much-newer 11.0.2809.24. This is a code path update only, and is meant only for testing this new functionality. If you are running SQL Server 2012 in production, please do *not* bother deploying this CTP. The RTM service pack, when it is released, will have all of the patches and bug fixes you would expect (though it will still be subject to the leapfrog mechanism that typically locks out fixes from the cumulative update that immediately precedes the service pack). I'd expect the next cumulative update sometime around August 15th, and I do *not* expect the RTM for Service Pack 1 before then. If money were involved, I'd bet that Service Pack 1 will include the features you find in the CTP, and the fixes from CU1 & CU2.

In the meantime, you can download the CTP and read about it on the SSAS blog:

And of course the standard disclaimer for CTPs applies:

The CTP3 release of SP1 is not supported by Microsoft in production environments.

SQL Server 2012 Service Pack 1 is available!

AaronBertrand — Sat, 31 Mar 2012 23:12:00 GMT

Microsoft has released Service Pack 1 for SQL Server 2012. ~~Though so far it is only being made available for the x64 platform.~~ You can download here:

http://www.microsoft.com/en-us/download/details.aspx?id=35575

And read about the fixes in the following KB article:

http://support.microsoft.com/kb/2674319

And new features are detailed here:

http://msdn.microsoft.com/en-us/library/bb500435

The build # ~~appears to be the same as RTM: 11.0.2100~~ is 11.0.3000. ~~Which may mean it's just a ploy to bring on board all those folks who still think it's necessary to wait for SP1~~. I haven't tried installing it yet, as I'm still on travel, but please let me know if you have any issues.

Sorry, this was an April Fools' joke earlier this year but apparently it's kind of backfiring now. I talked about this update a little more in my post about the November 7th PASS Summit keynote.

How to Install Master Data Services (MDS) Service Pack 1 (for SQL Server 2008 R2)

mattande — Tue, 16 Aug 2011 21:47:00 GMT

[This post was created by Jason Howell, Senior Escalation Engineer in the SQL Server Support team specializing in MDS]

SQL Server 2008 R2 Service pack 1 was released in July 2011, as well as CU#1 for Service Pack 1 a few days afterwards, and CU #2 just yesterday August 15^th, 2011.

The purpose of this blog is to call out the difference in finding and running the download specifically for Service Pack 1, since it is packaged and extracted differently that Cumulative Updates. Other than the download & extraction steps, it is pretty much the same process as other Cumulative Updates for MDS. Steps 1 and 3 are the main differences here as compared to this this prior blog post.

Installing the Service Pack 1 for MDS requires manual intervention in this release, and running the typical Service Pack 1 setup for the other parts of SQL Server itself is not enough to patch MDS databases and websites.

If your server does not have an existing MDS installation, you can install a fresh copy of MDS following these steps in MSDN: Installing and Configuring Master Data Services You can use the SP1 MSI to install a fresh copy of MDS if needed.

If you already have a copy of MDS up and running, you can patch the existing instance with Service Pack 1 updates.

Always test the update and upgrade process in a non-production environment before applying an update and upgrading the MDS database in your production environment.

1. Download SQL Server 2008 R2 Service Pack 1

The first step is to download the service pack.

You can use this link to download the English version, or change the language as needed. http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26727

For example get the file SQLServer2008R2SP1-KB2528583-x64-ENU.exe

However, wait until you have read Step 3 to run the download.

A. It’s worth noting that the MDS Service Pack 1 download package looks different than the CU downloads.

Service Pack 1 does not have a specific MDS download like the CU’s downloads have. Pick the SP1 for x64.

Note: The KB for 2008 R2 Service Pack 1 (KB2528583) is located here: http://support.microsoft.com/kb/2528583

B. What’s in SQL Server 2008 R2 Service Pack 1?

Service Pack 1 includes fixes for SQL Server 2008 R2 CU1 through CU6 plus a few other fixes that are not in the RTM CU’s. Read the Kb for an exact list of the additional fixes not in CU1-CU6.

Moving forward, fixes made in the RTM cumulative updates are also ported forward to the next subsequent cumulative update for SP1. However, fixes made to the SP1 cumulative updates will NOT be ported back to the RTM unless there is express need to do so. This makes SP1 updates favorable moving forward to get the most fixes.

The green cumulative updates for MDS are included in Service Pack 1. The orange items below are carried forward in CU#1 for SP1. To get the latest updates, then use SP1 CU2 instead of SP1 itself. The list grows every 2 months, so refer to this list if in doubt which one is latest.

RTM & Updates
- 10.50.1600.1 Release to Manufacturer – May 10, 2010
- 10.50.1617.0 RTM Security Patch MS11-049 (2494088) June 14, 2011
- 10.50.1702.0 RTM CU #1 (981355) May 18, 2010
- 10.50.1720.0 RTM CU #2 (2072493) June 21, 2010
- 10.50.1734.0 RTM CU #3 (2261464) Aug 16, 2010
- 10.50.1746.0 RTM CU #4 (2345451) Oct 18, 2010
- 10.50.1753.0 RTM CU #5 (2438347) Dec 20, 2010
- 10.50.1765.0 RTM CU #6 (2489376) Feb 21, 2011
- 10.50.1777.0 RTM CU #7 (2507770) Apr 18, 2011
- 10.50.1790.0 RTM CU Security Patch MS11-049 (2494086) June 14, 2011
- 10.50.1797.0 RTM CU #8 (2534352) June 20, 2011
- 10.50.1804.0 RTM CU #9 (2567713) Aug 15, 2011
- etc…
SERVICE PACK 1 & Updates
- 10.50.2500.0 SP1 Release to Web (2528583) July 13, 2011 (contains RTM CU6 + others)
- 10.50.2769.0 SP1 CU #1 (2544793) July 18, 2011 (contains RTM CU7 - RTM CU8)
- 10.50.2772.0 SP1 CU #2 (2567714) Aug 15, 2011
- etc…

C. Instead of SP1 itself, you can alternately download CU2 (or later) for Service Pack 1

Instead of SP1 itself, you could run CU1 or CU2 (or later CU) for SP1 if you have business requirements to do so. There is a specific MDS file available for download for each CU, which contains only the piece to patch Master Data Services.

Since the MDS download contains a *.msi, it is unlike the rest of SQL feature area CU’s which use *.msp patches that require SP1 as a prerequisite to installing. Therefore you could use the SP1 CU2 file for a fresh install of MDS.

Cumulative Update 1 for SP1: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2544793&kbln=en-us
Cumulative Update 2 for SP1: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2567714&kbln=en-us
Future SP1 updates will be linked from this article: http://support.microsoft.com/kb/2567616

When you fill out the request page, as shown above the hotfix website will send you an email with the link to download the CU update.

2. MDS Preparations – stop current activity, backup your MDS Database, check the starting version

The upgrade process is two-fold: First, Upgrade the binaries. Secondly, upgrade the database schema

Therefore, before we begin, let’s stop all current activity so that we have a clean and safe copy of the MDS database in a consistent state, and make a backup of the MDS database and transaction log to be sure we have a safe copy just in case.

A. Stop the IIS web site or application pool.

This will keep users out of the system while we do the upgrade maintenance. You may want to alert the MDS users about the scheduled maintenance according to your businesses' change control processes.

Open Internet Information Services (IIS) Manager and stop the Master Data Manager Web application and the MDS Web service (if enabled). You can do this either by stopping the application pool that contains the Web application and service, or you can stop the Web site that contains them. If you stop the application pool, you stop requests for all applications in that application pool. If you stop the Web site, you stop only traffic to the Web site and any applications and services it contains.

B. Stop any query or maintenance operations

Such as scheduled jobs, reports, or custom applications that interact with the MDS database directly.

You could stop your SQL Agent service temporarily if unsure about scheduled jobs that might affect MDS data.

C. Backup the MDS database and the transaction log

You get to pick the name of your MDS database when you originally set it up with the Configuration Manager, so your database name may vary.

If you use FULL recovery model on the MDS database, you can back up the transaction LOG also.

Use a TSQL query or SSMS backup as you please.

BACKUP DATABASE MDS TO DISK='C:\mybackups\mds_before_sp1.bak'

BACKUP LOG MDS TO DISK='C:\mybackups\mds_log_before_sp1.trn'

Object Explorer in SQL Server Management Studio:

D. Query mdm.tblSystem in the current MDS database.

Review value for SchemaVersion and note the value, so you can compare the value after you apply the MDS update to verify that the value has been increased. The SchemaVersion may vary based on the build you are starting with. Some MDS Patches do no schema upgrades, but some do. Depending on which version you start from, Service Pack 1 may or may not upgrade the schema.

USE MDS
GO
SELECT * FROM mdm.tblSystem

3. Run the Service Pack 1 executable and msi’s

The SP1 download SQLServer2008R2SP1-KB2528583-x64-ENU.exe is a self-extracting zip. You can run SP1 for all of SQL if you want (see step 3A) or manually extract just the Master Data Services *.msi if needed (see step 3B).

Double-clicking the .exe extracts SP1 to a temp folder on the root of the drive

After extracting, it will prompt you with security UAC to run the service pack 1 setup.

A. Option 1: Run SP1 for all SQL Server feature areas first, then find the MDS msi.

If you need to patch all of the features of your SQL Server with Service Pack 1, follow the normal steps in the GUI.

Running SP1 will extract the MasterDataServices.msi file but it will not run it automatically.

After you have finished patching SQL Server 2008 R2 with Service Pack 1, you can then find the MSI for MDS in the setup bootstrap folder. It’s kept here for caching purposes:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache\KB2528583\ServicePack\1033_enu_lp\x64\setup\ masterdataservices.msi

On my computer it is in this folder, but I imagine the language (1033=English) may vary based on which SQL locale you have used in the installation.

Within that folder, click the MSI to run the MDS SP1 setup masterdataservices.msi

B. Option 2: Manually Extract SP1 if you do not need to patch any other parts of SQL.

If you don’t need to patch the other features of SQL Server, or maybe you need to just patch MDS as a separate step, you can manually extract the Service Pack 1 and get to the MSI. Several 3rd party compression tools let you right click on the .exe and extract it to a folder of your choosing as well.

From a command line, you can run:

SQLServer2008R2SP1-KB2528583-x64-ENU.exe /extract

Find the MDS msi in the specified location, in the subfolder:
<Extracted folder>\1033_enu_lp\x64\setup\masterdataservices.msi

4. Run the masterdataservices.msi manually (like any other MDS update)

Run through the installation until it completes

Note: If you start the MDS website at this point and visit it, you may get a version incompatible error. This is expected behavior when the schema version increases because the MDS binaries are upgraded, but the database is not yet upgraded. Users cannot use MDS yet if you see this message.

Client Version: 10.51.2500.0
Database Version: 1.0.0.0
The Client version is incompatible with the Database version. Please ask your administrator to upgrade the Client components or the Database components or both.

Note the binaries and scripts are upgraded already to 10.50.2500.0 (the build number of R2 Service Pack 1)

Binaries are the *.exe or *.dll in the Master Data Services installation folders such as

C:\Program Files\Microsoft SQL Server\Master Data Services\Configuration\

C:\Program Files\Microsoft SQL Server\Master Data Services\WebApplication\bin

When you right click on them in Windows Explorer, and view the properties, you can check the file version:

5. The Master Data Services Configuration Manager may need to run to complete the MDS database schema upgrade.

A. Run Configuration Manager

It will try to run automatically after the setup completes, or you can run it later from the start menu. Complete the additional steps therein to upgrade your MDS Database and your MDS Websites.

B. Connect and select your database

In the MDS Configuration Manager, click the [Select Database…] button.

Get connected to your MDS database on whichever SQL Server it may reside on. Note if you utilize a named instance, you have to manually type in the servername\instancename because the configuration manager forgets which instance to connect to every time.

C. Upgrade your MDS database if needed

If you see the below red error text "This database requires an upgrade. You cannot change system settings until the database is upgraded" then you need to upgrade your MDS database.

Sometimes you do not see this text, if you already had the schema upgrades are already in place from a prior cumulative update patch, then no further action is required, skip to step 6.

If you get the error after you picked the database server and the existing database name, in the MDS Configuration Manager, use the [Upgrade Database…] button to upgrade the database.

D. Click through the Upgrade Database Wizard

When you run the Upgrade, you will see several screens in the upgrade wizard. It will show which schema upgrades need to happen. It’s easy, so I’ll just show the progress bar:

E. Now check the database SchemaVersion in your MDS database by running the query to confirm the schema is now upgraded.

I expect 1.0.7.0 for Service Pack 1.

USE MDS
GO
SELECT * FROM mdm.tblSystem

6. Start the MDS website and Application Pool and make sure it works.

A. Start the web site and application pools

After the database upgrade is complete, your users can start using the MDS website again. Start the Website and or Application Pools, and remember to enable any SQL Agent jobs or other maintenance you may have disabled for the upgrade timeframe.

B. Browse through your MDS website to make sure the models are present, and that things seem normal.

You can get IIS to help you if you forgot the URL:

You can confirm the version number in the Help menu (blue question mark on the upper right of on the web page).

The MDS website shows the version as 10.51.2500.0 for Service Pack 1.

Cumulative Update #2 for SQL Server 2008 R2 SP1 is available

AaronBertrand — Tue, 16 Aug 2011 14:47:00 GMT

Last night Microsoft has released Cumulative Update #2 for SQL Server 2008 R2 Service Pack 1. The build # is 10.50.2772 and it contains 14 fixes, a few of which are wrong-results bugs or cases of access violations.

You can download the update here:

KB #2567714 : Cumulative update package 2 for SQL Server 2008 R2 Service Pack 1

It was also mentioned on the SQL Server Release Services blog. It seems to be implied that some of these fixes were included in CUs 7 or 8 for RTM but were left out of SP1 and SP1 CU1, but I haven't validated that by performing a diff.

My necessary disclaimer these days: This update is NOT for SQL Server 2008, and it is NOT for SQL Server 2008 R2 RTM.

New cumulative updates for SQL Server 2008 SP1 & SP2 are available!

AaronBertrand — Mon, 18 Jul 2011 21:28:00 GMT

In addition to SQL Server 2008 R2 SP1 CU1, Microsoft today also released cumulative updates for the SQL Server2008 branches (Service Pack 1 and Service Pack 2). You can download these updates from the following KB articles:

KB #2555406 : Cumulative update package 15 for SQL Server 2008 Service Pack 1
(Build number = 10.00.2847)

KB #2555408 : Cumulative update package 5 for SQL Server 2008 Service Pack 2
(Build number = 10.00.4316)

Slipstreaming

And if you want to slipstream one of these CUs with its associated base service pack, you can follow Peter Saddow's instructions here (the specific file names are different, but the concept is exactly the same):

http://blogs.msdn.com/b/petersad/archive/2009/04/16/create-a-merged-slipstream-drop-containing-sql-server-2008-server-pack-1-and-a-cumulative-update-cu-based-on-server-pack-1.aspx

To be clear...

As a reminder, these cumulative updates are only for SQL Server 2008 SP1 (10.00.2531 -> 10.00.2846) and SP2 (10.00.4000 -> 10.00.4315), not for SQL Server 2008 RTM (10.00.anything less than 2531) or for SQL Server 2008 R2 (version 10.50.anything).