Data source is the same thing. If you delete a datasource, the record should get removed.

Run backups with checksum

Perform Regular Checkdb (you can do that before or after your backup jobs - but it depends on your environment as to when and how you do...

The record is removed if you delete the subscription.

Have you checked that the backup path is available and that the service account has permissions to that path?

It looks like a bad path specified in your maintenance plan as...

If you are an hourly employee, then if they expect you to work extra hours - they should expect to pay for it. It's a lot of difference between...

Best practice is to backup your database and transaction log as required by recovery objectives put forth by the business.

Thanks Ron.

Lynn Pettis (3/10/2013)

---

GilaMonster (3/10/2013)

---

Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do this...

Try this

If not exactly what you need, it should get you some ideas at least.

select job_name, MAX(run_datetime) AS run_datetime, MAX(run_duration) AS run_duration,t.stop_execution_date

from

(

select job_name, run_datetime,t.stop_execution_date,

...

Good to hear. Thanks for the feedback.

This would be my inclination as...

Fraggle-805517 (3/9/2013)

---

General question here, but I am under the impression that a clustered primary key index, is essentially the table itself. If that is the case, does it make...

Jeff Moden (3/9/2013)

---

masoudk1990 (3/9/2013)

---

Hi.

I recognized if we store an image in binary type in SQL SERVER they take more space. For example a 700kb image take about 900kb space.

With this...

Jeff Moden (3/9/2013)

---

To emphasize what Gail has stated,...

Then again, maybe a little more description on what you seek.

Are you just trying to eliminate dupes in your output, or eliminate dupes from the table?

If you are trying to...