The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
329 views

SQL Server 2008 with SP1 Updating to SP3

I am considering applying this Service Pack 3 in a SQL Server 2008 with SP1, however I was not able to find if there are any drawbacks in this process, specially regarding to Replication Services and ...
4
votes
1answer
2k views

Failed Upgrade from SQL Server 2005 sp2 to SQL Server 2005 sp4

SQL Server Standard 2005 sp2 32bit running on Windows 2003 Standard 32bit service pack 2. I attempted a service pack upgrade from sp2 to sp4 using SQLServer2005SP4-KB2463332-x86-ENU.exe and received ...
2
votes
2answers
1k views

Error during SQL Server 2008 R2 SP3 upgrade: MODIFY FILE failed. File 'MSDBLog' does not exist

I have just installed SQL Server 2008 R2 SP3 and after installing it and trying to start the SQL Server instance again, it won't come online. In the SQL Server error log I can see that the following ...
2
votes
1answer
180 views

How to pull a list of applied service packs and cumulative updates from SQL Server 2008 R2?

I want to list all the SPs and CUs applied to a SQL Server 2008R2 instance. Example: 10.50.4260 2720425 http://support.microsoft.com/kb/2720425 CU#1 for SQL Server 2008 R2 SP2 10.50.4000 2630458 ...
2
votes
0answers
59 views

How can service pack rollback file end up on non-system volume?

I'm attempting to upgrade a SQL 2005 SP3 clustered instance to SP4. During installation, a rollback event took place with the error indicating there was insufficient space on the the disk. The system ...
1
vote
2answers
7k views

How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0?

I have SQL Server 2012 with version 11.0.3000.0 . I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...
1
vote
2answers
250 views

Install SP 3 on SQL Server 2008, where merge replication is running

I have a SQL Server 2008 and I should install Service Pack 3 for it. On my server there are several databases replicated, and mobile devices sync data via merge replication. Can problems occur, if I ...
1
vote
1answer
632 views

What are the hazards of upgrading a SQL Server service pack?

Are there any specific pitfalls/standard considerations when upgrading an instance of MS SQL Server to a higher service pack? Is there anything special that is generally done besides making sure there ...
1
vote
0answers
32 views

SQL Server 2008 R2 Cluster Service pack 3 fail to failover node

I have a SQL Server R2 cluster on Windows 2008 R2 boxes, and today i was to install SP3. I installed it without any errors and rebooted the passive node. When i then try to failover to the passive ...
1
vote
0answers
1k views

SQL Server 2008 R2 Service pack 3 won't recognize all instances

I have two instances on one of my servers, and when installing service pack 3 the GUI installer does not recognize one of the instances. Server is Windows Server 2008R2 Enterprise x64 SP1 Both ...
0
votes
2answers
146 views

SQL Server 2014 Latest CU / Service Pack

Where can you find the latest SQL Server 2014 Cumulative Update (CU) and/or Service Pack? Note: I added this question and answered my own question to make this easier to find for others in the ...
0
votes
1answer
344 views

How to update SQL Server 2005 clustered instances?

We have a 3 node cluster with an instance running on each. Windows 2003 R2 32bit (16GB) / SQL Server 2005 I want to bring them all up to build 9.00.5266 (SP 4 + CU3) (1 Node is already updated) The ...
0
votes
1answer
101 views

Error 29527: While upgrading from SP1 to SP4 in SQL Server 2005

We are trying to upgrade from SP1 to SP2 in SQL Server 2005 test box for a named instance. Initially we got the error MSP Error: 1260 Windows cannot open this program because it has been ...
0
votes
1answer
113 views

Breaking changes between 2008R2 RTM going to 2008R2 SP3?

I have a few A/P FCIs running 2008R2 RTM, and I'd like to upgrade the passive node to SP3, fail over, and then upgrade the formerly passive node. Has anyone else attempted this? Are there breaking ...
0
votes
0answers
44 views

How Can I Convert SQL Server 2012 Version 11.0.3000.0 to SQL Server 2012 Version 11.1.3000.0? [duplicate]

I have SQL Server 2012 with version 11.0.3000.0 . I need upgrade my version to SQL Server 2012 SP1 because I need install Cumulation 4 in Sql Server 2012 Cumulative Update 4 for use PowerPivot in ...