解决SQLSERVER 系统数据库MSDB “可疑”的方法.docxVIP

解决SQL Server2008 msdb可疑的数据库的方法请参考文章/sqlservertip/2571/restoring-sql-server-system-databases-msdb-and-model/ProblemDue to a recent rebuild of the master database for a SQL Server instance, I now need to restore the msdb and model databases.? In this tip we walk through the process that you need to follow to restore the model and msdb databases successfully.SolutionBefore we get started, lets quickly discuss what the msdb and model databases are used for.The msdb database contains scheduled jobs, alerts and backup history therefore a proper backup plan should be implemented for the msdb system database. The model database is the blue print for creating any new user database for that particular instance of SQL Server. DBAs can modify the model database with whatever settings that are required and when a new user database is created it will reflect the configuration of the model database. If the model database has been modified then it should be backed up. Hence both the msdb and model databases may need to be recovered in scenarios like database corruption, a rebuild of the master database or after a new server configuration. The restore process of msdb or model demands additional considerations than that of a user databases.?The restore process may get complicated if versions are not tracked and exclusive access is not ensured in all aspects. In the next sections we will go through the restore process for the msdb and model databases. Note: this exercise was performed on SQL Server 2005, but the same rules would also be applied on SQL Server 2005 and onwards.Backup msdbUse the following command to create a full backup of the msdb database using T-SQL commands. You will need to modify the script to use a valid backup path.? You can perform the same process for the model database as well.--Script 1: Create backup of msdbUSE [master]GOBACKUP DATABASE [msdb] TO DISK = NE:\MSDB_Backup.Bak WITH INIT,NAME = Nmsdb Backup for MSSQLTips DemoGOAfter this is complete we have a fu