there is also log shipping and database snapshots you could throw into the mix as potentials

If you want to replicate virtually all your database objects then log shipping with standby...

y.koteswarrao-652921 (10/13/2009)

---

Hi,

Backup Scenario

sunday 5 pm - full backup

Daily 7 pm - differital backup

Every 15 min - Transacional backup

Thrusday at 8:25 pm system was crash, what is approach in bringing the...

i am assuming that S:\ is a mapped drive. normal culprit for these errors is that the account under which the sql agent service is running does not have...

even though the snapshot agent is running that shouldnt affect the subscription unless you run the reinitialise command.

is this a production server? only reason i ask is it would be nice to change the sql agent to run under a domain admin account and that should...

Do any of your mail alerts work on your sql jobs? try just doing a simple job that does a select statement and on the alert system send a...

ok i assume you are not getting anything in the failed events table then. Sounds like your agent job isnt even getting as far as sending a message to...

ok, im still searching for the origional article i read some months back, however i have found another post with a link to MS documentation that seems to support what...

Mark_Pratt (10/6/2009)

---

Melton (10/6/2009)

---

However, the caveat, if you bought a single processor license but your server has 2 processors in it, you are not in compliance with licensing. I have...

Can confirm that app_name() works perfectly in the logon trigger.

thanks again

Thanks Elliot (and Jack) i will just use the app_name alongside the eventdata data. I just find it odd they dont include it in the eventdata when its...

No luck, still comes through as null in the application name field when doing a connection from SSMS (not tried any others). Maybe its the "FOR LOGON" bit which...

Try running this script and let us know what you see in the failure description, or if you are not seeing anything at all

use MSDB

go

select EL.Description as FailureReason, FI.* from...

edit - just read your post properly and you have already done what i suggested 🙂

DML triggers are stored against the table you created them against. In SSMS expand the table you created it on and look in the triggers node. if it...