Thanks!

I kinda figured it out

Create table inventory_server(

ServerID int PRIMARY KEY,

Memory int,

Edition varchar(200),

Version varchar(200),

CoreCount int)

Declare @serverID int,

@Memory...

No backup or log backup job is running.

New Testing:

TestDBSize 1.048GB

Rows Inserted 2097152(00:00:09)

Rows Inserted 4194304(00:00:23)

Rows Inserted 8388608(00:00:66)

Rows Inserted 16777216...

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.