You can restore a backup of the master database on another instance of SQL ServerĪs long as it's the same version of SQL Server, then use the restored files to replace the corrupt files on the broken system. The easiest way to rebuild the SQL Server master database is: It can be so troublesome, a lot of people consider reinstalling SQL Server from scratch! If that's what you're facing, then this may be a big help. But rebuilding the master database is usually quite time-consuming and frustrating, with a substantial amount of trial-and-error, especially if it's on a cluster. That's because SQL Server won't start with a corrupt master database. If your SQL Server master database becomes corrupt, such as from its disks losing power while SQL Server was running, the conventional advice is to rebuild the master database, start SQL Server, then restore the backup of the master database.
First published on TECHNET on Feb 01, 2011
0 kommentar(er)
