The fix for this issue was first released in Cumulative Update 9. Resolution SQL Server 2008 R2 Service Pack 1 Note SQL Server Agent should start after all the databases have recovered. After you install Cumulative Update 2 for SQL Server 2008 SP2 or you upgrade SQL Server 2008 to SQL Server 2008 SP3 or you upgrade SQL Server 2008 R2 to SQL Server 2008 R2 SP1, SQL Server Agent starts just after the MSDB databases finish recovering. This issue occurs because the user database is not finished recovering when the job starts. In this scenario, the SQL Server Agent job fails. You create a SQL Server Agent job on a user database, and you set the schedule type as Start automatically when SQL Server Agent starts. Upgrade SQL Server 2008 R2 to SQL Server 2008 R2 Service Pack 1 (SP1) or a later version of the service pack Upgrade SQL Server 2008 to SQL Server 2008 Service Pack 3 (SP3) Install Cumulative Update 2 for Microsoft SQL Server 2008 Service Pack 2 (SP2) or a later version of the cumulative update package Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 SP2 fix release. Microsoft distributes Microsoft SQL Server 2008 SP2 fixes as one downloadable file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |