Feb
21
2013

Why there is separate package for SQL Native Client (SNAC) on cumulative update download page?

If you are wondering that Cumulative Update download page has a package for SNAC, should you download and install or not? Then probably you will find your answer below.

 

Everything about SNAC is clearly explained at following link,

http://blogs.msdn.com/b/psssql/archive/2009/10/23/should-i-have-a-snac-with-my-cumulative-update.aspx

 

Just to brief it out,

 

What is SNAC?

SNAC stands for SQL Native Client

 

Why separate package is there on download page?

It is a package only to apply updates to native client (majorly if you are using Linked Sever queries) and its size is comparatively less from whole package.

 

Do I need to install SNAC as well and Cumulative update package?

Answer is NO, because main cumulative update package contains SNAC updates as well

 

Where do I need to install SNAC?

You can install SNAC update on servers which uses this feature and don’t have either SQL Client or SQL Server installed

 

You can download and install SNAC components from main package as well; SNAC package comes separate just to save you some download bandwidth and time to copy the package from one server to another.

 

If you have SQL client or SQL server installed then better to download full cumulative update and apply.

 

Hope it helps!

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: