Partition Corruption Impact on whole db

Question

Post reply

Partition Corruption Impact on whole db

striker-baba

SSCrazy

Points: 2170
More actions
June 12, 2019 at 5:25 pm

#3652851

I would like to know if corruption/unavaialability of one partition would impact whole DB? Will I still be able to access rest of the partitions?
Can I take one partition offline and have rest of the DB available.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

striker-baba wrote:

I would like to know if corruption/unavaialability of one partition would impact whole DB? Will I still be able to access rest of the partitions? Can I take one partition offline and have rest of the DB available.

As with all else in SQL Server, "It Depends". See the following by one of the masters on this subject.

https://www.youtube.com/watch?v=4w8KlUQg04U

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

So... enquiring minds want to know... did the link help you or not?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

prettsons SSCertifiable Points: 7453 More actions · Answer 4

You can read this blog: https://www.mssqltips.com/sqlservertip/1914/sql-server-database-partitioning-myths-and-truths/

SQL Database Recovery Expert 🙂