How to re-create Master Database SQL 2000

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

gbn SSCertifiable Points: 6429 More actions · Answer 1

In C:\Program Files\Microsoft SQL Server\80\Tools\Binn, run rebuildm.exe.

For more info, read BOL.

The only gotcha mainly is when you browse for the mdf and ldf files... make sure they are not "read only"

After creating this new master mdb, you'll have no logins, databases, jobs, alerts, etc at all.

So hopefully you'll have restores of all databases to pull everything back form...

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

The master database is found from a path in the services entry. You can correct this if you need to because paths have changed.