Get the version of source server on which the backup was created. ![]() Get the version of the destination server.To prepare for a smooth restore we need carry out these tasks: Notice that when SQL Server is installed or upgraded and whenever Setup.exe is used to rebuild the system databases, the recovery model of msdb is automatically set to simple. For more information, see Recovery Models (SQL Server). ![]() If you use the backup and restore history tables, we recommend that you use the full recovery model for msdb. The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail.īy default, msdb uses the simple recovery model. Here are some information about the msdb database before we start: ![]() To ensure a successful restore of the msdb database, follow these two simple major steps:
0 Comments
Leave a Reply. |