How to rebuild system databases in SQL Server 2005

When system databases are rebuilt, all database objects and data in master, model and msdb system databases are removed. Rebuilding the master database installs all system databases to their initial location.

To rebuild the system databases you need to run the setup command from the Command prompt and follow the following procedure:

1. Click Start, click Run, type cmd, and then click OK.
2. Run the following command to rebuild the system databases:

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

For example:

start /wait D:\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=p@ssw0rd

Notes about this procedure:
 

	Put the media (CD or DVD) on the same location from which you originally installed the instance of SQL Server 2005.
	The /qn switch makes all Setup messages, including error messages, to be written to Setup log files. The main log is located at %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
	The /qb switch can be used instead of the /qn switch. /qb allows the display basic setup dialog boxes and all error messages.
	SAPWD is needed to specify a new password for the System Administrator account. Microsoft recommends de use of a strong password.
	The parameter INSTANCENAME is used to specify the instance name. Use MSSQLSERVER for the deafult instance.

The above procedure is often used to rebuild the master database for a corrupted installation of SQL Server.

References:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

TechEd video

SCCM

• Microsoft System Center Configuration Manager v.Next: Device Management;
• Planning and Deploying Forefront Endpoint Protection 2010 with Microsoft System Center Configuration Manager;
• Microsoft System Center Configuration Manager 2007: SP1 Technical Update;
• System Center Configuration Manager v.Next: Application Management;
• Microsoft System Center Configuration Manager 2007 R3 & v.Next: Overview;
• Microsoft System Center Configuration Manager 2007: Scripting and Console Extensions;
• Microsoft System Center Configuration Manager 2007: R2 Overview;
• Servicing Windows XP Embedded Devices Using Microsoft System Center Configuration Manager;
• Microsoft System Center Configuration Manager 2007: End Point Security Configuration and Network Access Protection;
• Microsoft System Center Configuration Manager v.Next: Hierarchy Design;
• Deploying Windows 7 with System Center Configuration Manager 2007;
• Deploying Microsoft System Center Configuration Manager 2007, Part 1: Site Deployment;
• Deploying Microsoft System Center Configuration Manager 2007, Part 2: Client Deployment;
• Microsoft System Center Configuration Manager v.Next Technical Demonstration;
• Microsoft System Center Configuration Manager 2007: Software Updates for the Enterprise – a Day in the Life of the Update Administrator;
• Microsoft System Center Configuration Manager 2007: Desired Configuration Management;
• Microsoft System Center and the Green Client;
• Troubleshooting Microsoft System Center Configuration Manager 2007 OS Deployments;
• Native Mode in Microsoft System Center Configuration Manager;
• What´s New in Microsoft System Center Configuration Manager SP1 and R2;
• Microsoft System Center Configuration Manager v.Next: Migration from Configuration Manager 2007;
• Techniques for Managing Drivers with Microsoft System Center Configuration Manager and Microsoft Deployment Toolkit 2008;
• What’s New in Microsoft System Center Configuration Manager: SP1, R2, and R3;
• Deploying System Center Configuration Manager 2007 – Part 1;
• Deploying System Center Configuration Manager 2007 – Part 2;
• Software Distribution in Microsoft System Center Configuration Manager V.next: Part 1;
• Software Distribution in Microsoft System Center Configuration Manager V.next: Part 2;
• Advanced Operating System Deployment with Microsoft System Center Configuration Manager (Part 1 of 4);
• Advanced Operating System Deployment with Microsoft System Center Configuration Manager: Extending OS Deployment with the Microsoft Deployment Toolkit (Part 3 of 4);
• Advanced Operating System Deployment with Microsoft System Center Configuration Manager: Provisioning Your Windows Deployment with Microsoft Deployment (BDD) (Part 4 of 4);
• Microsoft System Center Configuration Manager v.Next: Overview;
• Upgrading from Microsoft Systems Management Server (SMS) 2003 to Configuration Manager 2007;
• Advanced Operating System Deployment with Microsoft System Center Configuration Manager (Part 2 of 3);
• Advanced Operating System Deployment with Microsoft System Center Configuration Manager (Part 3 of 3): Extending OS Deployment with the Microsoft Deployment Toolkit;
• Microsoft System Center Configuration Manager 2007: Overview;
• Ensure your Security Baseline Compliance with Security Compliance Management DCM Configuration Packs;
• Microsoft System Center Configuration Manager 2007: Asset Intelligence 1.5;
• Microsoft System Center Configuration Manager v.Next: Software Distribution.

System Center

• Securing the Microsoft Cloud with Microsoft System Center and Microsoft Forefront Families of Products;
• Using Microsoft System Center to Manage beyond the Trusted Domain;
• Private Cloud Reference Architectures with Hyper-V and System Center;
• System Center and the Datacenter;
• Virtual System Center: Running and Maintaining The System Center Suite on Microsoft Hyper-V;
• Opalis IT Process Automation: Introduction and Technical Overview;
• Connectors for Service Center: The Microsoft Interoperability Strategy;
• Planning for Microsoft System Center Operations Manager 2007 and Microsoft System Center Virtual Machine Manager 2008 Using the New Infrastructure Planning and Design Guides;
• Using Microsoft System Center Tools to Deliver Virtualization Management for Hosting and Service Providers;
• Easing the pain: Techniques for managing drivers with System Center Configuration Manager, MDT 2010, WDS, and more;
• System Center Client Management – What’s Now and Future;
• Interoperability Connectors for Microsoft System Center;
• Using Windows Deployment Services and Microsoft System Center to Deploy and Manage a Point-of-Service System Running Windows Embedded POSReady;
• Dynamic Infrastructure Toolkit for Microsoft System Center Deployment: Architecture and Scenario Walkthrough;
• Automating and Simplifying Compliance and Risk with System Center;
• HP Insight Control for Microsoft System Center;
• Microsoft System Center Roadmap and Strategy;
• Application Virtualization with Microsoft System Center;
• Reducing TCO with Intel® manageability technologies and Microsoft® System Center products;
• Microsoft System Center Operations Manager and Virtual Machine Manager: Monitoring the Service Stack;
• Hyper-V and Microsoft System Center: Practical Orchestration and IT Process Automation Recipes;
• Managing vSphere with Microsoft System Center;
• Extending Microsoft SCOM & Virtual Machine Manager Monitoring and Reporting with Veeam;
• Optimize Your Client Health and Performance with Microsoft System Center.

SCE

• Supporting Your End-Users with Microsoft System Center Essentials 2007;
• Microsoft System Center Essentials 2010 = Integrated Virtual and Physical IT Management for Medium-Sized Businesses;
• Microsoft System Center Remote Operations Manager 2007: Deployment and Configuration;
• What’s New for Microsoft System Center Essentials 2010?;
• Technical Introduction to Microsoft System Center Essentials 2010;
• Supporting Your End-Users with Microsoft System Center Essentials 2007;
• What’s Next for Microsoft System Center Essentials.

SCOM

• The Microsoft System Center Operations Manager Top 20 Must-Have Customizations;
• Monitoring .NET Applications with Operations Manager 2007;
• Introducing the Next Generation of System Center Operations Manager;
• Microsoft System Center Operations Manager 2007 R2: Driving Compliance with ACS;
• System Center Operations Manager present and future;
• Cross-Platform Monitoring with Microsoft System Center Operations Manager 2007;
• Overview of the New and Updated Management Packs in Microsoft System Center Operations Manager 2007;
• Developing Custom Reports and Operational Dashboards with Microsoft System Center Operations Manager 2007;
• Service Level Dashboard for Microsoft System Center Operations Manager 2007;
• Understanding Security Features within Microsoft System Center Operations Manager 2007;
• Planning a Successful Microsoft System Center Operations Manager 2007 Deployment with Microsoft System Center Capacity Planner 2007;
• Microsoft System Center Operations Manager 2007: Administrative Best Practices;
• Advanced Management Pack Authoring;
• Microsoft System Center Operations Manager 2007: Audit Collection Services;
• Microsoft System Center Operations Manager 2007 R2: Service Levels, Reports, Dashboards, Report Authoring, and More!;
• Monitoring UNIX/Linux with Microsoft System Center Operations Manager 2007 R2;
• Monitoring Applications on UNIX and Linux with Microsoft System Center Operations Manager 2007 R2;
• What’s New Since the Release of Microsoft System Center Operations Manager 2007 R2;
• Extending Microsoft System Center Operations Manager 2007;
• System Center Operations Manager 2007 cross platform extensions;
• Keeping Your CIO Happy: Sharepoint 2007 SLA Scorecarding with Operations Manager 2007 and SQL Server 2008;
• Distributed Application Monitoring with Microsoft System Center Operations Manager 2007;
• What’s New in Microsoft System Center Operations Manager 2007 SP1;
• Getting the most out of Operations Manager 2007 Reporting;
• Building Effective Operations Management Scorecards and Dashboards;
• Microsoft System Center Operations Manager 2007 R2 Tips from the Field;
• BI for IT: Visio Services Add-in for Microsoft System Center Operations Manager 2007 R2.

Trouble with setup due to SQL not being detected?

If you have run into issues during setup where you know that you have a supported version of SQL running on your machine but setup in unable to detect it, you may have hit a SQL WMI provider issue. In OpsMgr 2007 R2, this shows up as the SQL Server requirement in the Prerequisite Checker failing.
Setup calls WMI in order to check SQL version to determine if the SQL version meets the prerequisites. Once you have verified that you do in fact have SQL installed on the machine and that it is indeed a supported version of SQL, check if the WMI provider is the the issue by trying to connect to SQL using SQL Server Configuration Manager. You should receive an error that reads:
"Cannot connect to WMI provider. You do not have permission or the server is unreachable. Not that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class."
The solution for this issue is to recompile your MOF file, which can be done using the steps detailed in this blog: http://msmvps.com/blogs/martinpoon/archive/2009/11/27/sql-server-configuration-manager-cannot-connect-to-wmi-provider-invalid-class-0x80041010.aspx