Eric Russell 13013 (9/9/2010)

---

The following query should give you the last 3 backups for each database and include the columns: database_name, recovery_model, backup_type, size_gb, backup_start_date, backup_finish_date, and duration_minutes.

...

That's true Gail (although I'm starting to feel a headache coming on).

You may have helped us immeasureably.

GilaMonster (9/9/2010)

---

Double-check by reading the SQL error...

I spoke with someone who (hopefully) knows this here and I'm told that our version of DPM (2007) does do the log backups.

He also says that a differential/incremental backup is...

Thank you both.

What I understand from Gail's reply is, with respect to the log backups then, since we use DPM here, the best place to look would be in the...

Hi,

I'm not a DBA, and visit these forums to learn, not to post. However, I'm thinking:

Would this behavior occur if the table once held a lot of records, and they...

Jeff,

Stay folksy. Your articles are great the way they are.

I'm new to the forums and not a DBA by profession. I read the posts and articles here to broaden my...

Hi Daniel;

That seems a perfectly sensible use for identity insert. However, in your example, I don't see it as inserting a duplicate value, more like reusing an identity value that...

Yep,

I got this one wrong also.

However, it begs the question, "why would you want an identity column in the first place if you intend to insert a duplicate value?"