Shulou(Shulou.com)05/31 Report--

This article focuses on "how to restore the Master database in SQLServer2000", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to restore the Master database in SQLServer2000.

Method 1:

Reinstall SQL, but the data is Over.

Method 2:

Rebuild the installation file used by SQL for Master Rebuildm.exe and copy the original file from the installation directory X86\ Data. After the reconstruction is successful, do not start SQL Server and enter SQL in single-user mode

\ bin\ sqlservr.exe-m

Restore backup

Restore database master from disk='e:\ master.bak'

Restore Master

Then start SQL Server

Sp_addumpdevice 'disk',Mas,' E:\ Master.bak'

Backup database master to mas

Restore verifyonly from mas

Cut the Master db

Rebuildm.exe

Sqlservr.exe-m

Restore database master from disk='e:\ master.bak'

If the Model database has been damaged, it is necessary to rebuild the Master database first, and then restore the backup of the Model database; the damage of MSDB does not affect the normal operation of SQL Server, and the backup restore is the same as the user database. Since the SQL Server database is rebuilt using the Model database every time it is started, you don't have to back up any more.

At this point, I believe you have a deeper understanding of "how to restore the Master database in SQLServer2000". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.