Perry Whittle (6/30/2015)

---

Ok, now we know where to target our efforts

Chitown (6/30/2015)

---

Both instances are running under Network Service.

Both...

D:\Program Files\Microsoft SQL Server\MSSQL10_50.****\MSSQL\Log

g.britton (6/30/2015)

---

I have no idea what Venus is. However, you need to ensure that appropriate permissions are in place. Here's a simple way to find out:

Login to...

Perry Whittle

Which job?

There are 3 jobs per LS plan!!

Both instances are running under local system?

Both instances on the same computer?

You'll need to provide a lot more info, not just simply...

g.britton (6/30/2015)

---

Have you followed this:

If the SQL Server service account on your primary server runs under the local system account, you must create your backup folder on the primary server...

Environment Details:

On the Primary Server:

Agent is running under LocalSystem

Backup job runs successfully everyday

Transactional Log job runs successfully every hour.

Index rebuild job runs successfully as well.

However, when I run the LSCOPY...

It fails even when I try to run the Agent as a "Venus" user. Venus user has all the access to different directories. I even restarted the agent but it...

It is working but why is it that it worked when I tried running it as an administrator?

Thank you so much for taking your time out and providing me with some suggestions and the issue has been resolved.

This is what I did.

add user to the DatabaseMailUserRole role

sp_addrolemember...

I had a job that ran at 11 and it was supposed to send out alerts when the job runs successfully and it didn't work. No email received.

I just did. Let's see what happens. Thanks for your help.

Sorry...

What happens if there is no activity in the DB? The job will run regardless but will it send out email notification even if...

Thank you:-). I am assuming this is all I need other than setting up DB mail and SQL job to run this procedure.