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?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Below link would guide you on that:

http://msdn.microsoft.com/en-us/library/ms175535.aspx
0
 
Rahul GuptaConnect With a Mentor Commented:
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 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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 GuptaConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.