when/how do you determine PAGE_VERIFY for a database?

for a DB that you inherited or you designed, what factors/considerations will you use/see to determine what PAGE_VERIFY setting to set for the user database?

thanks.

DatabasesMicrosoft SQL Server 2008

Last Comment

25112

8/22/2022 - Mon

SOLUTION

Aneesh

7/16/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

25112

7/16/2015

ASKER

>>you should use CHECKSUM,
is that a best practice standard.. would you want to keep any of the other options at any other scenarios/situations?

What/where is a new database getting its PAGE_VERIFY on creation? from MODEL database?

SOLUTION

Aneesh

7/16/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

ASKER CERTIFIED SOLUTION