question

Håkan Winther avatar image
Håkan Winther asked

Page verify for SQL 2012 Master Data Service

A client of mine installed Master data service and they haven't changed any db options, but the PAGE VERIFY is not set to CHECKSUM. Does anyone have an idea why Master data service is installed without checksum? Personally I didn't exepect to see torn page detection in "new" databases.
best-practicemaster-data-servicessql server 2012database-optionspage-verify
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
Did you check the settings on database [model]? I don't see any reason not to change the setting to CHECKSUM
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.