Below mentioned is the command to rebuild master in SQL2008. This is no different in SQL Server 2008 from 2005, but the command line switches have changed some and the process behind the scenes to rebuild the system databases (master, model, and msdb) is also a bit different.
setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=vcn\it-got-sql-admins /SQLCOLLATION=Latin1_General_CI_AS /SAPWD=sapassword
Ref:
http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx
No comments:
Post a Comment