I would reccommend checking your Agent job (LS_RESTORExxxx) and see if you can track down when the errors began, it should tell you which TRN file started causing the problem,...

Lowell (1/27/2012)

---

you only need to grant EXECUTE on a stored procedure.

by design, if the user has EXECUTE permissions, whatever the proc does, whether INSERT/UPDATE/DELETE, the proc will run successfully, and...

Just so you know, it's the string function that gives you the non-SARGable predicate in the WHERE clause:

WHERE this = that AND

(CONVERT(char(10), a2.timestamp, 120) = @date)

As suggested, changing it...

If you add in what Gail and Drew have mentioned, you'll most likely see another significant performance gain. Chances are if you're running the optimized version that was provided...

Not sure what the limitiations are but since you have SQL Server, the best solution would be to import the access database into a SQL database, and connect the access...

SELECT

EMP_ID,

ROUND(SUM(CAST(EMP_MINUTES_WORKED as money))/60 ,2) [EmpHours]

FROM EmpHours

GROUP BY EMP_ID

?

How large is the clustered index? A fair measure of how large your log file needs to be can be...

When the job is running actually running it shows the numbers above, after a step has actually completed it records the step number to the last_executed_step_id column in the msdb.dbo.sysjobactivity...

1 - Data loss is not appreciated..Hardly a couple of hours of data should be ok

2 - Full recovery models

3 - Definitely transactional based environment

4 - I didn't understand this?...

Please be more specific:

1) What's an "acceptable" amount of lost data? i.e. Anything since the last full backup? 2 hours of data? 6 hour? NONE?

2) What recovery...

This is a rather large and open question (really more information is needed to more accurately answer your question)...What is the customer's SLA on downtime? What kinds of things...

I've encountered this issue before as well, but usually it's an issue with the network copy (as Dev and Gianluca have already mentioned). Restoring the DB from it's point...

But I'm being somewhat pedantic.

The function is named as returning the job status but is in fact only returning the last executed job step ID.

How is that job step ID...

Correct. I wrote this to monitor job status (instead of using the xp_sqlagent_enum_jobs method - as that results in having to insert the result set into a temp table,...

The two functions need to be use together. One returns the guid from the provided name, the other uses the guid to fetch the status