SQL 2008 Master DB Rebuild

Question

Hi,

I am trying to rebuild the master DB (SQL 2008 )to change my default Collation but am getting the below result, anybody please help me on this

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2>Setup
/QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=SQLSERVER /SQLSYSADMINACCOUNTS=Buil
tin\administrators [ /SQLCOLLATION=SQL_LATIN1_GENERAL_CP1_CI_AS]
Microsoft (R) SQL Server 2008 R2 Setup 10.50.1600.01
Copyright (c) Microsoft Corporation.  All rights reserved.

The following error occurred:
Exception has been thrown by the target of an invocation.

Error result: 1472388962
Result facility code: 1986
Result error code: 57186

Answer 1

check this url ,

http://www.mytechmantra.com/LearnSQLServer/Rebuild_System_Databases_In_SQL_Server_2008.html

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

Hello,

This is a known issue when you run SQL Server 2008 RTM setup from a local drive. Try to run setup from a DVD drive or use a media with SP1 included. For more information, please see the following thread:

http://connect.microsoft.com/SQLServer/feedback/details/564905/rebuilding-system-databases-for-sql-server-2008-r2

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 3

How to Rebuild System Databases in SQL Server 2008
http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

---

Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 4

Hi Babu,

Thanks for your Link but this is what i have did before.

---

Regards, Nithish Ramanath Green Earth is safer than the Blue Earth… Please don't print this Email unless you really need to.

Answer 5

Hi Nithish,

Please rebuild system databases with SQL Server 2008 R2 installation media. The following document lists the detail steps to do, you can refer to them.

Rebuilding System Databases:
http://msdn.microsoft.com/en-us/library/dd207003(v=sql.105).aspx

---

Allen Li
TechNet Community Support

Answer 6

Hello,

This is a known issue when you run SQL Server 2008 RTM setup from a local drive. Try to run setup from a DVD drive or use a media with SP1 included. For more information, please see the following thread:

http://connect.microsoft.com/SQLServer/feedback/details/564905/rebuilding-system-databases-for-sql-server-2008-r2

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

---

Regards, Nithish Ramanath Green Earth is safer than the Blue Earth… Please don't print this Email unless you really need to.

Answer 7

this worked

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/1fc6bae5-c66a-4832-bfc6-daf53baf1890

Answer 8

have you tried

Answer 9

Hello,

Just wanted to confirm that this is a known problem when you run setup.exe from the following location:  C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

The workaround is to go the installation media (Where you installed SQL Server from) and run the setup.exe that is in that location to rebuild the system databases.

Please let us know if this resolves the issue for you.

Sincerely,

Rob Beene, MSFT