How To rebuild a master database in SQL Server 2005?

Hi All,
I have to change the collation setting on my server to the old collation settign I have.
So I want to rebuild the master database and Can some one tell me the procedure for rebuilding the master database?
saratcmAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Below link would guide you on that:

http://msdn.microsoft.com/en-us/library/ms175535.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rahul GuptaCommented:
Rebuild master database in sql server 2005
Here are the instructions on how to rebuild master database. This would be useful during DR.

SQL SERVER 2005 install media should be restored to the same location from where sql server was installed originally.

The location can be found from SQLSetup001__SQL.log ? Search for Product in this log file. This point to the location from where the sql server 2005 was installed from.

Copy the software to this location

Go the sql server configuration and change the properties to startup manual and stop the sql server services

Then run the command after changing to location where sql server media exists

start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=

Default instance name is MSSQLSERVER

Again stop the sql server services and bring up the instance in single user mode by executing

sqlservr.exe -m ( Need to change directory to location where sql server was installed. generally it will be in D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn)


Now log on sql server management studio and restore the master database from backup. After the restore is completed,
error message will be displayed. Ignore this and close the management studio.

Start the sql server services from sql server configuration manager or from services in administration tools.

Restore user databases. If the user databases were part of replication then

Right click databases.
Restore database.
Then select the location where the backup resides.
Select the database name from drop down and select option to override the data files.




0
saratcmAuthor Commented:
I dont want to restore, I want to rebuilt the database with the new collation settings I want.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Rahul GuptaCommented:
0
saratcmAuthor Commented:
Hi Rahul,

The location can be found from SQLSetup001__SQL.log ? Search for Product in this log file. This point to the location from where the sql server 2005 was installed from.

Copy the software to this location
I didn't understand this, do I need to copy the setup file to some location you are suggesting or?

and -->start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI
where should I exe this cmd, In the cmd line?
will that do the rest?
0
Rahul GuptaCommented:
The location from SQLSetup001__SQL.log refers to the location from where the SQL Server 2005 was installed. For Example if it was installed from

C:\MSSQLSetup\                            --SQL Server Installer Location (Setup Files)

Create the Same folder and copy the installer (Setup) to the same location.
Now go to Location using command prompt

C:\MSSQLSetup and run the following command

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI




0
saratcmAuthor Commented:
Good
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.