Probability of a corrupt SQL Server installation after installing a component or SP

Question

Post reply

Probability of a corrupt SQL Server installation after installing a component or SP

Welsh Corgi

SSC Guru

Points: 116520
More actions
May 2, 2016 at 11:30 am

#313699

What is the Probability of a corrupt SQL Server installation after installing a component or SP?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

After creating an SP. 0.

What do you mean by 'component'?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

GilaMonster (5/2/2016)
After creating an SP. 0.
What do you mean by 'component'?

I meant Service Pack and Integrated Services.

Thank you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

And what exactly do you mean by 'Integrated Services'?

Service pack, only if it fails or breaks part way through.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

GilaMonster (5/2/2016)
And what exactly do you mean by 'Integrated Services'?
Service pack, only if it fails or breaks part way through.

Integrated services as in SSIS.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

The IS in SSIS stands for Integration Services, not integrated services.

And installing that is a separate service, so it won't mess with the database engine other than to create a database.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass