Hi,

I understand what you say that it's called too frequently, but it may help if it runs faster...

Can you post the index definition of the table Context, and tell me...

I don't think what you are trying to accomplish actually exists in SQL Server. You can't, in my knowledge, know what was executed within a certain transaction.

What you can do...

I have to admit you're right, in a real big environment with a lot of important data, that could be really important. Where I work, I'm the only DBA, and...

If I were you, I would look in a 3rd party that already have that kind of product.

Look into redGate, or DBGhost, both products work really nicely. I don't know...

GSquared (11/6/2009)

---

kkapferer (11/6/2009)

---

Thank you all for your suggestions. A more senior DBA here advised me that I was overthinking this problem. He suggested I just delete the...

Thanks a lot Roy, I think we all have the same concern about the time it takes and the quality of the backups that will be taken with those automated...

Nice, I heard it a few times, but never had the opportunity to use it. I will someday! 🙂

Nice job Lynn, curious to know what you have used to fix the data?

You have provided sample data for only 1 table, and it is not in the ""insert into table_name select values"".

Can you repost the sample data, so it's usable by anyone...

Lynn is right, with the DDL of the tables, sample data, and the expected output, people will jump in to try to answer you. It does not sound like a...

Guys, that confirms what I thought about using Backup Exec for Sql Backups.

I thank all of you for those great thoughts on the subject, and I'll of course fight against...

Roy Ernest (11/3/2009)

---

Also keep in mind that once you go to SQL 2008 you can always use the SQL Server native compressed back up that reduces the back up size...

Luke L (11/3/2009)

---

Also, I know you said you are not taking t-log backups, but if you are using differentials, the BE software may cause some issues with the log chain......

Luke L (11/3/2009)

---

Roy Ernest (11/3/2009)

---

There were couple of threads regarding this topic and the almost everyone thought that it was not a great idea since as a DBA you do...

On a different note, what do you guys think about that backup solution, am I the only one frightened by this software? http://www.sqlservercentral.com/Forums/Topic813200-357-1.aspx