rebuildm

rebuildm is a utility that you can use to rebuild system databases, including the master, msdb, and model databases, that are shipped with SQL Server 2000.

The syntax is as follows:

rebuildm

CAUTION

rebuildm needs to be used with extreme caution because it essentially copies the original versions of these databases over the copies that you have in your database. After rebuildm has been run, all of the information that you had in these databases prior to running rebuildm (including user database information, scheduled tasks, and default database settings) will be gone.

The rebuildm utility is typically used if the following situations exist:

  • A current backup of the master database is unavailable. If the backup were available, the ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial