Also, before you start rebuilding the master, you need to Note before rebuilding master, it is recommended to take a backup of the existing system databases in case your rebuild is not what you wanted so that you can go back to the previous configuration. On a normal installation, the setup.exe can be found atĬ:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release All the required files should be available on the server itself. There is no need to use the installation DVD or the installation files.
To rebuild the master database in SQL 2008, you need to use setup.exe. It does not use rebuildm.exe as it was the case in Sql Sever 2000 The method of rebuilding master and other system databases in Sql server 2008 has changed. SO, I decided to rebuild the master database. Recently I have build a two node Sql Server 2008 cluster to be used for one of our production servers and during testing we noticed that the tempdb and the other system databases on existing production server (SQL 2000) has a different collation that that the tempdb on the new cluster.
0 kommentar(er)
