Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Snapshot agent accessing Single User Mode database Expand / Collapse
Author
Message
Posted Friday, October 16, 2009 4:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 10, 2014 7:16 AM
Points: 53, Visits: 545
A bit of a confusing one this.
We have a database (A) that has multiple replication jobs on (local publication)
For some reason one job fails intermitently when starting the snapshot agent (I can see this in the job history).
The errror indicated the snapshot agent can't logon to a database (B) because its in single use mode (error 924)
Only problem is that this database (B) has nothing to do with the replication job on database (A)!
Post #804078
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse