this is a message I get in the event properties,

18052 :

Error: 9003, Severity: 20, State: 1

Yes please MSSQLSerice is not starting

MSSQLSERVER and SQLSERVERAGENT

yes database engine is running, but th issue with the services

that's correct, I will keep that in mind Thanks Again

Thanks a Lot, it is fixed, it was a space issue,

I get this message at the Alert Job,

Message

Executed as user: sa. The log shipping secondary database ISLRPTSQL.CnSx has restore threshold of 840 minutes and is out of sync. No restore...

Microsoft (R) SQL Server Log Shipping Agent

[Assembly Version = 10.0.0.0, File Version = 10.0.5500.0 ((Katmai_PCU_Main).110922-0336 )]

Microsoft Corporation. All rights reserved.

Message

2012-02-16 10:33:36.16----- START OF TRANSACTION LOG RESTORE -----

Message

2012-02-16 10:33:36.26Starting...

database is simple

No I do not

Hello, yes I would highly appreciate if someone can get me the diagram made for me,

we have one Sql server in our network, then we have AS400, one server where...

Thanks a Lot, really appreciate,

It is working for me, we are testing on the development server,

Thanks & Regards,

Dev

Thanks a Lot, the only difference I see is the quesry you send me the very 1st time, it creates the trigger and when I try using cnsuser, it ...

Hello,

Thanks for your help, I guess it is going to help me, just couple of things, I am trying this in my development environment right now,

1- How I can drop...

Hello, actually I do not want him to connect using cnsuser, but on the otherside I do not want that if I add the trigger as above, I do not...