• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

Apply sql server 2005 service pack 1 then 2 or just service pack 2?

I currently have SQl server 2005 installed but have no service packs applied.

Do I have to apply sql server 2005 service pack 1 then 2 or does service pack 2 contain service pack 1 anyway?
0
Ed
Asked:
Ed
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Not necessarily, you can apply sp2 directly .
0
 
EdAuthor Commented:

thanks

but why 'Not necessarily' could there be a situation where you would apply SP1 then SP2?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
ususally, people will apply sp1 first and then sp2.
0
 
SQL_SERVER_DBACommented:
SP2 has everything in it SP1 does and then some.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now