The tool provides a GUI that allows you to specify the source of the existing database file and the destination server, as shown in Figure 4.3. Microsoft provides a utility named rebuildm.exe that is located in the Program Files\Microsoft SQL Server\ 80\Tools\Binn subdirectory. In the event that your Master database is corrupted or destroyed and cannot be restored from backups, you can rebuild the Master database to its default state. The installation process creates the Master database (master.mdf) and master database log file (mastlog.ldf) in the Program Files\Microsoft SQL Server\Mssql\Data directory.
Given its importance to SQL Server, a current backup of the Master database is critical to any server recovery.
0 kommentar(er)
