x

Can we alter Master Database settings

Hi,

Is there a way to alter the Master database settings like collate, recovery, page_verify , read_committed_snapshot

Thanks.

more ▼

asked Sep 22, 2011 at 11:47 PM in Default

avatar image

pvsrinivasrao
174 26 27 30

Guys how to handle re-building Master DB are there any steps listed out ? I have a script to create Master DB can we use it while re-buliding the DB.

Sep 23, 2011 at 12:20 AM pvsrinivasrao

The link I provided details what to do to rebuild the master database.

Sep 23, 2011 at 12:58 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Chaging the recovery and page verify options of master can be done using the standard ALTER DATABASE command.

Changing the server collation (master database) requires you to rebuild the master database. This is a little more difficult, as it requires you to detach user databases, run the setup.exe and re-attach the user databases.

Read BOL to find out - however, that document says to drop the user databases, don't do that!! Detaching and re-attaching them should be sufficient.

more ▼

answered Sep 23, 2011 at 12:00 AM

avatar image

WilliamD
26.2k 18 35 48

(comments are locked)
10|1200 characters needed characters left

No, not all of those settings. You have to rebuld the master to change collation and you can't change read_committed_snapshot.

more ▼

answered Sep 22, 2011 at 11:59 PM

avatar image

Håkan Winther
16.6k 37 46 58

@Håkan Winther - collation changes require a rebuild, but not page_verify and recovery

Sep 23, 2011 at 12:02 AM WilliamD

True, I was in a hurry when I wrote my answer, and to be absolute clear. You have to rebuild master to change collation and you can't change read_committed_snapshot

Sep 23, 2011 at 12:09 AM Håkan Winther
Sep 23, 2011 at 01:01 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2188

asked: Sep 22, 2011 at 11:47 PM

Seen: 656 times

Last Updated: Sep 22, 2011 at 11:54 PM

Copyright 2017 Redgate Software. Privacy Policy