Skip to main content

Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005

Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005: "Subsystem % could not be loaded"

"The Snapshot subsystem failed to load"


SYMPTOMS
loadTOCNode(1, 'symptoms');
Consider the following scenario. You perform one of the following actions in Microsoft SQL Server 2005:
• You restore an msdb backup.
• You attach an msdb database.
• You change the information in the syssubsystems table in the msdb database.

Solution:
1.
In SQL Server Management Studio, run the following script.use msdb
go
delete from msdb.dbo.syssubsystems
exec msdb.dbo.sp_verify_subsystems 1
go
2.
Stop and then restart the SQL Server Agent service.
Labels:

Popular posts from this blog

Web synchronization option for merge replication

http://msdn2.microsoft.com/en-us/library/ms151319.aspx SQL Server 2005 Books Online Implementing Replication over the Internet Replicating data over the Internet allows remote, disconnected users to access data when they need it using a connection to the Internet. Replicate data over the Internet using: A Virtual Private Network (VPN). For more information, see Publishing Data over the Internet Using VPN . The Web synchronization option for merge replication. For more information, see Web Synchronization for Merge Replication . All types of Microsoft SQL Server replication can replicate data over a VPN, but you should consider Web synchronization if you are using merge replication.
Post a Comment
Read more

Request Signatures in Blackberry

Request Signatures in Blackberry need copy sigtool.db, sigtool.csk to SDK/component/Bin folder for example V 4.2.1 ../eclipse\plugins\net.rim.eide.componentpack4.2.1_4.2.1.17\components\bin
Post a Comment
Read more